I have a small survey. Before knowing the results, I created for the first
question, on the first worksheet, sample responses and a dynamic chart - a
single-series bar chart. For the other questions, I copied that worksheet.
The chart on the first sheet works perfectly. The charts on the other sheets
do not work properly. The series function for these charts reflects the sheet
that the chart is on, but the source data for these charts points back to the
original chart in the first worksheet. So, any changes that I make to the
first sheet are reflected in all the charts. Any changes that I make to the
subsequent sheets do not affect their corresponding charts. Can anyone please
tell me what is the problem and its solution?
Thanks