In this lesson we’ll look at how to move charts from one state to the other.
Let’s take a look.
To move a chart into its own sheet, first, opt for chart.
Then, go to the Design tab under Chart Tools and hit the Move Chart button.
You could also give the chart a different name at this point.
The new sheet will be to the left of the sheet you started on.
Standalone charts are more spacious than embedded charts.
You’re free to change the page orientation 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 snag the chart, right-click, and choose Move Chart from the menu.
This works in both directions.
Finally, note that the Move dialog does two things.
It allows you to change the location of a chart, but it also reports the current location.
