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

[Jack Bader]

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

 

[Debra Dalgleish]

Jon Peltier has instructions for creating dynamic charts:

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