Create a Chart With Relative Rather Than Absolute Data

[PeCoo2]

Is there a way to create a chart that has relative rather than absolute data?

I am trying to be able to copy a chart from one worksheet to another and have it automatically pick up data in the new worksheet.
At the moment whenever I try to do this the chart will still link back to data in the worksheet I copied it from.

I have multiple worksheets set up to show forecasts for different markets but I am having to manually change the data source each time, very frustrating.

 

[RoryA]

No there isn't. You could use code to change the source data.

 

[PeCoo2]

OK Rory, Thanks for letting me know.

Looks like I'll just plod along doing it manually.