Microsoft Office Tutorials and References
In Depth Information
Formatting text
set of numbers, using the No Fill option is good way to get there. (A sparkline can serve this
purpose as well, of course, but sparklines—described in the previous chapter—are
available only in a small number of chart types.) Eliminate the border around the chart area (as
discussed in “Formatting lines and borders” earlier in this chapter), get rid of any chart
elements you don’t want (the title, legend, or whatever), and assign the No Fill option to your
chart and plot areas. Figure 20-6 shows an example of a chart reduced to basics in this way.
Figure 20-6 Less is sometimes more. Applying No Fill to this chart’s chart area eliminates
Formatting text
The simplest way to carry out most formatting tasks for chart titles, axis titles, axis labels,
and other chart text is to select the text and then use the familiar commands in the Font
group of the Home tab. You can change the font, size, and color of chart text this way, for
example. You can format particular words in a title by selecting them, just as you might do
with ordinary worksheet text, and you can employ the standard keyboard shortcuts, such
as Ctrl+B for bold or Ctrl+I for italic. Note, however, that you cannot format individual axis
labels in this manner; formatting directives in that context apply to the entire set of labels.
Using WordArt
When any text element on your chart is selected, Excel makes the WordArt Styles group on
the Format tab available. For information about using WordArt, see “Creating WordArt,”
in Chapter 10, “Creating and formatting graphics.” In addition to a gallery of readymade
WordArt styles, the WordArt Styles group offers three commands—Text Fill, Text Outline,
and Text Effects—that you can use to dress up your chart text. If you’re interested in adding
some visual lair to chart titles and other textual elements, be sure to experiment with these
Search JabSto ::

Custom Search