Microsoft Office Tutorials and References
In Depth Information
Notice that the task pane displays two choices along the top: Title Options and Text Options. Click
Title Options, and you see three icons: Fill & Line, Effects, and Size & Properties. Each of these icons
has its own set of controls, which can be expanded or contracted by clicking the triangle icon to the
left of the category name.
Similarly, the Text Options choice displays three icons: Text Fill & Outline, Text Effects, and Textbox.
Again, each of these icons has its own set of options that you can expand or collapse using the triangle
So, if you want to change the color of the text in a chart’s title by using the Format Chart Title pane,
you would follow these steps:
1. If the Format pane is displayed, click the chart’s title; if the pane is not displayed,
double-click the chart’s title.
2. In the Format Chart Title pane, click Text Options at the top.
3. Click the Text Fill & Outline icon.
4. Expand the Text Fill section.
5. Choose a color from the Color control.
At ﬁ rst, the Format pane will seem complicated and confusing. But as you get acquainted with it, it
gets much easier to use.
Also, keep in mind that many formatting choices are available on the Ribbon. For example, a quicker
way to change the text color in a chart title is to select the title, click the Home tab on the Ribbon, and
use the Font Color control.
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 ﬁ rst (or use Page Layout view) to ensure that
your charts don’t span multiple pages. If you created the chart on a chart sheet, Excel
always prints the chart on a page by itself.
If you select an embedded chart and choose File ➪ Print, Excel prints the chart on a page by itself and does not print
If you don’t want a particular embedded chart to appear on your printout, access the
Format Chart Area pane and select the Size & Properties icon. Then Expand the Properties
section and clear the Print Object check box.