F
Fodder937
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?
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?