Microsoft Office Tutorials and References
In Depth Information
Chart Styles and
To choose a style, select the chart, and then head to the ribbon’s Chart Tools |
Design ➝ Chart Styles section, which gives you a gallery of choices (Figure 19-21).
Note: If you’ve resized your Excel window to be very small, the chart styles don’t fit in the ribbon and you
see a Quick Styles button instead. Click this button to see the full list of styles.
Scroll buttons: see more choices
Click any of the Chart
Style options to dress
your chart up in
different colors. The
scroll bars (circled)
let you move through
the style options not
currently shown, or
click the down arrow
to see a drop-down
window with all your
Down arrow: see all choices
A chart can use only one style at a time, so if you choose a new style, Excel wipes out
the existing formatting.
Chart styles make it easy for you to change the colors and visual styling in a chart.
Chart layouts are complementary—they let you control the presence and placement
of various chart elements, like the chart and axis titles, and the legend.
As you’ll learn in the next section, Excel lets you tweak each of these ingredients
separately. However, you can choose a prebuilt layout to do it all in one shot. To try it out,
head to the ribbon, and then make a choice from the Chart Tools | Design ➝ Chart
Layouts section. As with styles, the list of available charts depends on the chart type.
Figure 19-22 shows an example.
Note: To make chart layouts as practical as possible, the creators of Excel reviewed thousands of
professional charts and identified the most common arrangements. Most Excel pros still want to customize the
various parts of their chart by hand. However, a chart layout can provide a great starting point.