In this tutorial, we are going to learn how to move a chart in Excel into a chart sheet.
Moving a chart to another sheet is as simple as 1, 2, 3. Simply add a new sheet, and then copy and paste the chart into it.
But hold up, as in here, we’re going to teach you how to move a chart onto another chart sheet. Even confused? Here’s a quick rundown of a chart sheet: A chart sheet in Excel is a worksheet that contains only a chart.
Moving on, let’s proceed to our tutorial.
How to Move a Chart to a Chart Sheet (Tutorial)
Time needed: 1 minute.
Here’s a step-by-step tutorial on how to move a chart in Excel to a chart sheet.
- Click the chart, the chart design tab, and then the move chart button.
The first thing we should do is click the chart we ought to move, then the chart design tab and the “move chart” button.
- Select “new sheet,” then click OK.
When the move chart button is clicked, a modal window will appear. In the modal, select the New Sheet button, then click OK.
Note: You can change the label of the chart if you please.
After clicking the OK button, here’s the result:
The pie chart was moved onto a chart sheet.
Note: Moving the chart back to its original location is the same process as moving it to the chart sheet. The difference is that you select the “object in” button instead of the “new sheet button” (see the second step).
Tip: The alternative way of moving a chart into a chart sheet is to click the chart, right-click, and then select "move chart." After that, the process is the same as the one above.
Move the chart to another worksheet
The following is a step-by-step guide on how to move a chart to another worksheet. The process is kind of alike above, yet here it is.
1ST STEP → Aside from the sheet containing your chart, add another worksheet to which you want to move your chart (if you already have one, skip this step).
Back to your chart, click your chart, then the chart design tab, and then the move chart button.
2ND STEP → After clicking the move chart button, a modal window will appear. In the modal, select the drop-down list, select the sheet where you’ll locate your chart, then click OK.
Note: You can also copy and paste the chart from one sheet to another.
Resize a Chart
In resizing a chart, we have to make sure we’re not also resizing the cells. Since you’ve read this far, let me show you how to resize a chart in Excel as an added bonus.
1. Click the chart, then the Format tab.
The first thing we do is click the chart, then the Format tab.
Note: In the picture provided, the format tab hasn’t clicked yet.
2. Click the height and width boxes and enter the size.
After clicking the format tab, you’ll see below it the shape height and shape width in the size group.
To change the size, enter the size you desire for your chart in the height and width boxes.
Aside from above, you can also click the dialog box launcher if you want to change the size and scale of the chart.
You do the same when you change it. Just click the height, width, scale height, and scale width boxes and enter the numbers that you want.
Note: You can manually change the size of the chart by simply clicking and dragging the sizing handles.
In conclusion, this tutorial is the key to making our work in “moving a chart to a chart sheet” easier and more effective.
I think that’s it for this tutorial. I hope you’ve learned something from this. If you have any questions, please leave a comment below, and for more educational content, visit our website.
Thank you for reading.