Microsoft Office Tutorials and References
In Depth Information
As with other drawing objects (such as a text box or a shape), you can move an
embedded chart, resize it, change its proportions, adjust its borders, and perform
other operations. Using embedded charts enables you to print the chart next to the
data that it uses.
To make any changes to the actual chart in an embedded chart object, you must
click it to activate the chart. When a chart is activated, Excel’s menu changes: The
Chart menu replaces the Data menu.
When you create a chart on a Chart sheet, the chart occupies the entire sheet. If you
plan to print a chart on a page by itself, using a Chart sheet is often your better
choice. If you have many charts to create, you may want to create each one on a
separate Chart sheet to avoid cluttering your worksheet. This technique also makes
locating a particular chart easier because you can change the names of the Chart
sheets’ tabs to provide a description of the chart that it contains.
Excel’s menus change when a chart sheet is active, similar to the way that they
change when you select an embedded chart. The Chart menu replaces the Data menu,
and other menus include commands that are appropriate for working with charts.
Excel displays a chart in a chart sheet in WYSIWYG mode: The printed chart
looks just like the image on the chart sheet. If the chart doesn’t fit in the window,
you can use the scrollbars to scroll it or adjust the zoom factor.
You can also size the chart in a Chart sheet according to the window size by
using the ViewSized with Window command. When this setting is enabled,
the chart adjusts itself when you resize the workbook window (it always fits
perfectly in the window). In this mode, the chart that you’re working on may
or may not correspond to how it looks when printed. Figure 1-3 shows a
Chart sheet with the Sized with Window setting enabled, and Figure 1-4
show the same chart without this setting enabled.
If you create a chart on a Chart sheet, you can easily convert it to an embedded
chart. Choose Chart
Location and then select the worksheet that holds the
embedded chart from the As Object In drop-down box. Excel deletes the chart sheet and
moves the chart to the sheet that you specify. This operation also works in the
opposite direction: You can select an embedded chart and relocate it to a new Chart sheet.
A Chart sheet can also contain one or more embedded charts. You can use
the ChartLocation command to move embedded charts to an existing
Chart sheet. The second drop-down box in the Chart Location dialog box
includes Chart sheets as well as worksheets.