How can i move a chart sheet and / or all of its chart panes to a different chart?
- I have two distinct charts in my layout.
- Chart 1 has Sheet 1 & Sheet 2, each with multiple chart panes.
- Chart 2 has Sheet 1 & Sheet 2, each with multiple chart panes.
- How can I save and/or move Chart 1,Sheet 1 to Chart 2, Sheet 3?
(I realize I can save each of the Chart 1, Sheet 1 - chart pane’s formula, then drag them into my new sheet, but I am hoping there is an easier way!)