In this video, we’ll look at how to move charts from one state to the other.
But you’ve got the option to also move a chart to a sheet all by itself.
To move a chart into its own sheet, first, opt for chart.
Then, go to the Design tab under Chart Tools, and smack the Move Chart button.
The new sheet will be to the left of the sheet you started on.
If you visit Page Setup, you’ll see the chart occupies the entire page.
You’re free to change the page orientation here if you like.
To move the chart back to Sheet1, click Move Chart again.
This time, select Object in, and choose Sheet1.
you’ve got the option to also right-click to move a chart.
Just pick the chart, right-click, and choose Move Chart from the menu.
This works in both directions.
