[Dropped] Copy & paste a chart to a different month
Posted: Thu May 04, 2023 8:56 pm
I have a chart on the Jan page which draws its data from that page.
When I copy the chart to the Feb page, it continues to draw its data from the Jan page.
I notice that on the Jan page, the chart has a format option "Data Ranges".
But when I copy the chart to the Feb page, it loses that format option.
Is there a way to copy the chart and make it refer to the page it is on, rather than the page it came from?
Thanks for any clues.
When I copy the chart to the Feb page, it continues to draw its data from the Jan page.
I notice that on the Jan page, the chart has a format option "Data Ranges".
But when I copy the chart to the Feb page, it loses that format option.
Is there a way to copy the chart and make it refer to the page it is on, rather than the page it came from?
Thanks for any clues.