change range for multiple charts

[Yossi evenzur]

Hi
I need to change the range for multiple charts, i.e. i have to go chart by
chart and modify, either with the mouse or by typing, the new range, is there
a quicker way to do this?

 

[Dnyaneshwar Gaikwad]

Hi
I need to change the range for multiple charts, i.e. i have to go chart by
chart and modify, either with the mouse or by typing, the new range, is there
a quicker way to do this?

 

[Jon Peltier]

I've written a little Excel add-in that performs mass edits of series
formulas:

How to Edit Series Formulas
http://peltiertech.com/WordPress/how-to-edit-series-formulas/

Scroll down a couple screens to find the link to the add-in.

- Jon