I want chart source data to be relative references, not absolute.

[Guest]

Everytime I try to enter the chart source data as a relative reference, Excel
automatically adds the dollar signs to make the references absolute. I have
12 groups of columns repeating data above the graphs. (The rows and the
columns are identical, except for the data entered in the variable cells.)
If the cell source data were relative, I could copy the original chart over
11 times and be done. Since it is not, I have to go in each chart and
manually edit the source data to adjust the column references. This is a
pain. Also, if we delete or add any groups of column data, which we need to
do all the time, the charts do not adjust, and I have to go in and edit the
chart source data references again. Does anyone know how to get around this
Excel automation?

 

[Wilgert]

*Everytime I try to enter the chart source data as a relative
reference, Excel
automatically adds the dollar signs to make the references absolute.
I have
12 groups of columns repeating data above the graphs. (The rows and
the
columns are identical, except for the data entered in the variable
cells.)
If the cell source data were relative, I could copy the original
chart over
11 times and be done. Since it is not, I have to go in each chart
and
manually edit the source data to adjust the column references. This
is a
pain. Also, if we delete or add any groups of column data, which we
need to
do all the time, the charts do not adjust, and I have to go in and
edit the
chart source data references again. Does anyone know how to get
around this
Excel automation? *

I have _exactly_ the same question. But it seems that it isn't
possible!