Quote Originally Posted by TMS View Post
b) not all charts have split ranges.
That doesn't actually make any difference - the series.formula property consists of 4 elements:
1. Series Name
2. XValues
3. Values
4. Plot Order

These elements are comma separated, so the SPLIT function just identifies the range of XValues and Values.

You may run into issues if the chart source is a direct data array, rather than a range... but that would also be easily handled.

Glad it pointed you in the right direction - thanks for the feedback