But sometimes it is better to have a standalone chart that fits on the sheet and fixed to its location.

Pie Chart In Excel How To Move Chart

In this article, we will learn how to move chart from one sheet to new chart sheet.

Select the chart and go to design tab.

You will see the move chart icon in right most corner of ribbon in excel 2016.

Click on it. 3. In move chart dialog box, click on new sheet radio button.

You can move other charts too on the same sheet but other charts will float around, while the first chart will be the background of sheet.

When you right click on the chart, you will see an option as move chart.

Move Chart From One Sheet To Another If you want to move the chart on a different normal sheet than select the object in: option.

From drop down, select the desired sheet name.

Hit Ok. The chart will be moved.

Move Chart From Chart Sheet to Normal Chart On chart sheet, right click on the chart.

Click on object in: and select the desired sheet from drop down.

Hit ok. The chart is moved back to the normal sheet.

So yeah guys, this how you can move charts to new chart sheets to have standalone charts in excel.

Let me know if you have any doubts regarding this article or any other article.

Pie Chart In Excel Code Be Liable

In no event shall the owner of the copyrights, or the authors of the applicationscode be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applicationscode.

Home About Advertise With Us Excel Tips and Tricks Excel Editing Excel Format Newsletter Get latest updates from exceltip in your mail.

Information about your use of our site is shared with Google for that purpose Accept Home About Us Advertise With Us Quiz Page Excel Forum Commercial Services Formulas and Function.

You can adjust all of your cookie settings by navigating the tabs on the left hand side.

Strictly Necessary Cookies Strictly Necessary Cookie should be enabled at all times so that we can save your preferences for cookie settings.

This means that every time you visit this website you will need to enable or disable cookies again.

Pie Chart In Excel For Mac