Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copying charts and their data with relative cell positions
I have a chart with a data table next to it. The looks of the data table and
the chart have been modified to the look I need, however I have to repeatedly show this same chart and data table multiple times in the same worksheet but with different data. What I want to do is copy the chart and it's corresponding data table and paste into into a different location on the spreadsheet. However when I do this the chart always keeps the original cell refernces. Apparently the chart uses absolute referncing instead of relative referncing. When I attempt to modify the chart's data source to use relative cell refernces - Excel just changes it back to absolute! Is there a way I can accomplish this task? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|