Excel 2010 For Dummies
Book image
Explore Book Buy On Amazon

Excel 2010 automatically embeds new charts on the same worksheet as the source data, but you may find it easier to work with a chart if you move the chart to its own chart sheet in the workbook.

On the Chart Tools Design tab, click the Move Chart button to open the Move Chart dialog box.

If you don’t see the Chart Tools Design tab, select the chart to make this tab appear.

Click the New Sheet option button in the Move Chart dialog box.

Click the New Sheet option button in the Move Chart dialog box.

This option places the chart on a new chart sheet that is added to the current workbook.

(Optional) Entering a more descriptive name to replace "Chart1."

This step is especially useful if you plan to have multiple chart sheets in the workbook.

Click OK to close the Move Chart dialog box.

The chart appears in its own chart sheet with the name displayed on the sheet tab.

About This Article

This article is from the book:

About the book author:

Greg Harvey, PhD, is president of Mind Over Media, Inc. He is the author of all editions of Excel For Dummies, Excel All-in-One For Dummies, Excel Workbook For Dummies, and Windows For Dummies Quick Reference. He's also an experienced educator.

This article can be found in the category: