Here is my problem
I have a bar chart on sheet1 of a spreadsheet; the source data for the chart is also on sheet1.
When I create a copy of sheet1 (now called sheet2) the chart on sheet2 still refers to sheet1 instead of sheet2 for its source data.
What I want is the chart on a particular sheet to always refer to the data on its own sheet for chart data.
Thanks