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? |
All times are GMT +1. The time now is 06:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com