Hi there

Column C in a table contains data which is pulled into a chart:

=Sheet1!C5:C13

I want the chart to pull data from column C even if I insert a new column
to the left of Column C. In other words, when the current Column C data
moves to the right and becomes Column D, I DON'T want the reference to change
to

=Sheet1!D5:D13

I want it to stay

=Sheet1!C5:C13

and reflect the new values that are in the new column C.

The Indirect function does this for a single cell, but I can't seem to make
it work for a range of cells as shown above. Any way to do this?

Every time a new column of data is added, I waste tons of time manually
changing all the cell references in about 100 charts, so that the charts are
built from the new data now in column C rather than the old data now in
column D. Any help would be appreciated.

Marlene