*** Dynamically changing Cell Ranges for Data ***

Hi,

I have a variety of charts, each with multiple sources of
data. I also have trendlines in these charts.

Each month I add a new column of data and I have to go
into EACH chart and manually change the cell ranges so
that the new column is included in the charts.

Is there a way to setup some way to make this easier...so
that I could enter the column in a cell and EACH place it
is used would automatically get updated?

Thanks,
Jack

Jon Peltier has instructions for creating dynamic charts:

http://www.geocities.com/jonpeltier/.../Dynamics.html


Jack Bader wrote:
I have a variety of charts, each with multiple sources of
data. I also have trendlines in these charts.

Each month I add a new column of data and I have to go
into EACH chart and manually change the cell ranges so
that the new column is included in the charts.

Is there a way to setup some way to make this easier...so
that I could enter the column in a cell and EACH place it
is used would automatically get updated?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html