Microsoft Office Tutorials and References
In Depth Information
it to select it; then drag it to the desired location in the chart. To delete a chart
element, select it and then press Delete.
When a chart is activated, you can select various parts of the chart to work with.
Modifying a chart is similar to everything else you do in Excel. First, you make a
selection (in this case, select a chart element). Then you issue a command to do
something with the selection. Right-clicking an element in a chart displays a
shortcut menu. This menu often (but not always) contains the command you need.
You can use the Fill Color tool on the Formatting toolbar to change colors. For
example, if you want to change the color of a series, select the series and choose the
color you want from the Fill Color tool. You’ll find that many other toolbar tools
work with charts. For example, you can select the chart’s legend and then click the
Bold button to make the legend text bold.
When you double-click a chart element (or press Ctrl+1 after selecting it), its
Formatting dialog box appears. The dialog box that appears varies, depending on
the item selected. In most cases, the dialog box is of the tabbed variety. Many
modifications are self-evident — for example, changing the font used in a title. Others,
however, are a bit more tricky.
Chapter 4 discusses these chart modifications in detail.
In addition, you can right-click a chart element and get a shortcut menu that
contains commands related to that element.
Printing embedded charts is nothing special; you print them the same way that you
print a worksheet. As long as you include the embedded chart in the range that you
want to print, Excel prints the chart as it appears on-screen. When printing a sheet
that contains embedded charts, it’s a good idea to preview first to ensure that your
charts do not span multiple pages.
If you select an embedded chart and then choose FilePrint (or click the
Print button), Excel prints the chart on a page by itself and does not print the