Use a macro to expand data series for chart?

K

Kevin Clark

How can I write a macro to expand each of the data series for a chart to
include one additional column?

I want it to work without knowing how many data series there are or what the
current range is. Basically, I want it to expand my ranges by one additional
column to the right.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Chart SERIES OFFSET 5
Convert Error Bars to Series and Colour 1
Chart series select. 3
Excel Chart auto data highlighting anomaly.... 1
XY scatter plot with more than 32000 rows in Excel 2003 0
Copy addition formula of non-consecutive horizontal cells 2
Expanding selected data 2
Gantt chart duration not showing 0

Top