Microsoft Office Tutorials and References
In Depth Information
Moving the chart to a separate chart sheet
Note that cell styles, table styles, and chart styles are all components of the current theme.
That is, when you change the theme applied to your workbook (by clicking Page Layout
on the ribbon and opening the Themes gallery at the left side of the ribbon), your
available cell styles, table styles, and chart styles all change as well. Also, be aware that theme
changes on your computer do not affect the appearance of your chart on someone else’s
computer; if your chart is full of pink, it might still look green to your coworker.
For more information about themes, see “Formatting with themes” in Chapter 9, “Worksheet
formatting techniques.” For more information about cell styles, see “Formatting with cell
styles” in Chapter 9. For more information about table styles, see “Customizing table styles”
in Chapter 22.
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,
specialpurpose 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 on the chart border or the plot area and
choose Move Chart (or select the chart and then 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, select the name of the worksheet you want to
move the chart to, and then click OK.
INSIDE OUT Press F11 to move a chart
You can move a chart object to a chart sheet by selecting the chart and pressing F11.
The only disadvantage to this approach is that you don’t get to name the chart sheet.
But you can always do that later by double-clicking the sheet tab and changing the
default name to something of your choosing. You can even create a chart on a chart
sheet directly from data—by selecting a cell or range and pressing F11. Here the one
disadvantage is that Excel uses the current default chart type, which might not be what
you want. But you can always switch to a different type by selecting the chart on the
chart sheet and clicking Change Chart Type.
Search JabSto ::




Custom Search