I want chart source data to be relative references, not absolute.
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 want chart source data to be relative references, not absolute.
Bob Mc wrote: *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! -- Wilgert ------------------------------------------------------------------------ Posted via http://www.mcse.ms ------------------------------------------------------------------------ View this thread: http://www.mcse.ms/message1686495.html |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com