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

  • Thread starter Thread starter Jack Bader
  • Start date Start date
J

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
 
Back
Top