macro for chart data range extension

M

mohavv

Hi,

I've 12 graphs with 6 lines each.

I want to extent the ranges of the lines and labels with 1 column
(already extists in data range).

Is there a way to run a macro that replaces the column label in all
the data ranges from $AH to $AI. Maybe for all the charts in the
worksheet at once?

Cheers,

Harold
 

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

Automatically shift chart data range: redux 6
delete range using VBA 1
chart macro 6
Macro 3
Saving a range for later reference 0
Automatically shift chart data range 4
Dsum and Dmax with structured references 1
Chart data - Range Names 1

Top