Using charts in Excel is a powerful way to visualize and represent data. Charts can help us to make complex data more understandable, reveal patterns, and provide insights. They are versatile tools that can provide valuable insights and make your data more accessible and understandable.
However, it is equally important to keep your charts simple and avoid clutter. Using charts also means it can occupy a lot of space in Excel and make your presentation look cramped. In such cases, you might want to move them to a new placeholder or sheet. This will also make them more manageable for presentation purposes.
In this article, we will learn how to move a chart from one Excel sheet to another. So, let’s dive into it.
Moving the chart to a new worksheet
Suppose you have created a chart using a data set and want to move the chart to another worksheet within the same workbook. The worksheet you want to move the chart should already exist in the workbook. You can follow the below steps for the given data set to get started.
Step 1: Click on the chart object you want to move. You’ll see a border around the chart indicating it’s selected.
Step 2: Navigate to the “Design” tab on the ribbon
Step 3: Click on the “Move Chart” icon under the Location group
Step 4: Once the move chart dialog box appears, select the “Object in’’ option in case you want to move the chart to an existing worksheet and then select the desired worksheet from the drop-down list.
Step 5: Select the “New sheet” option if you want to move to new worksheet and provide a name for the new sheet(if you wish) or the name of the existing sheet you want to move the chart to
Step 6: Click OK
The chart will be moved to the new sheet. Now, you can edit and format it as desired.
Remember, these steps will move the chart from the original worksheet and move it to the new worksheet in the same workbook.
However, if the need is to keep the chart in the original worksheet and also have a copy in the new one, you can create a copy of the chart using the copy and paste function and then move one of the copies to the new worksheet.
We will learn how to do that in the next section of this article.
Moving chart by copy-pasting
Another easy way to move a chart to a new worksheet is by copying and pasting it into the desired worksheet. It will create a copy of the chart in the new worksheet.
To completely move the chart from the original worksheet, you can keep the copied chart and delete the original or use the Cut-Paste function instead of Copy-Paste.
Here’s the step-by-step guide on how to copy and paste charts easily from one sheet to the other:
Step 1: Click on the chart object you want to move. You’ll see a border around the chart indicating it’s selected.
Step 2: Press “Control+C” or right-click and select “Copy” as shown in the screenshot
Step 3: Go to the new worksheet where you want to move the chart
Step 4: Press “Control+V” or right-click, select “Paste,” and select the ‘Destination Theme’ icon.
Step 5: The chart will be copied to the new worksheet. You can also delete the original chart from the previous worksheet if you want.
Pro-Tip: To paste the chart as an image, use the "Paste Special" feature. This is useful if you only want to show the chart for presentation purposes and don't want to alter the data.
Moving a Chart to a New Chart Sheet
Next, let’s start with another popular method of moving a chart from one sheet to another. If you want to move a chart to its own dedicated sheet, which will only contain that chart, you can use the following steps:
Step 1. Right-click on the chart you want to move. You’ll see a border around the chart indicating it’s selected.
Step 2: Click on “Move Chart”. This will open the “Move Chart” dialog box.
Step 3: Select the “New sheet” option
Step 4: Give a name for the new chart sheet
Step 5: Click OK
Step 6: The chart will be moved to a new sheet dedicated only to the chart. You can edit and format it as desired.
Note: You can also use the Keypad shortcut to use this method. Here are the steps to follow:
Step 1: Select the data
Step 2: Click on ‘F11’ on your keypad to create a chart on a dedicated sheet.
Once moved to the desired place, you can also resize the chart easily. Click on the chart and resize it by dragging its edges.
Knowing how to move a chart to a new sheet in Excel can come in handy if you want to keep your data organized. It is also beneficial when you want to view the chart in a larger space without any other data elements around it.
From the above-mentioned steps, we learned how to move charts to new sheet in Excel. We also learn how to move the chart within the same worksheet in more than one way.
We hope these methods will help you to customize the layout of your data visualization and make it more presentable. You can select any of the above-explained methods for moving a chart object to a different location within a worksheet or moving it to a chart sheet.
Other articles you may also like: