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?

"Yossi evenzur" wrote:

> 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?

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...ries-formulas/

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Yossi evenzur wrote:
> 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?