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?