Moving the Chart to a Separate Chart Sheet

If you don’t need to have your chart next to the numbers from which it is derived, you might consider putting it on its own chart sheet. A chart sheet is a separate, special-purpose sheet that gives the maximum amount of screen area to your graph. To move your chart from a worksheet to a chart sheet, right-click it, and choose Move Chart (or select the chart, and click Move Chart on the Design tab). In the dialog box that appears, select New Sheet, supply a name for the chart sheet (or accept the default name), and then click OK. If you decide to move the chart back to the worksheet, repeat this process, select Object In, type the name of the worksheet you want to move the chart to (or select it from ...

Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.