Microsoft Office Tutorials and References
In Depth Information
Changing the Chart Options
Choose from Theme
Colors, Standard Colors, or
apply pictures, gradients,
or textures to the selected
data point or series.
Color choices for the various parts of
your chart aren’t just cosmetic. Sure, you
like blue, or maybe your company’s logo
is green, so you want everything to
match. But another thing to consider is
color blindness. Ten percent of men and
7% of women have a form of color
blindness that makes it difficult or impossible
to tell green from red. This means that
you should avoid using green and red
together, because to this portion of the
population, both colors will just look gray.
This is especially bad if the colors are
adjacent, making, for example, two pie
slices meld together into one big gray slice.
Use the Design tab. This tab, also found
within the Chart Tools section of the
ribbon, offers some preset color
combinations that will recolor your entire chart—
all the bars, columns, lines, or slices.
To use them, just click on the chart itself
(to make sure it’s the active element on
your worksheet) and then just click the
Chart Styles button for the color scheme
you’d like to use. Note that there’s a scroll
bar at the end of this section of the ribbon
—meaning there are lots of styles to
choose from, in addition to the first eight
that appear as shown in Figure 11-17.
lines that give quantitative context to your
chart’s bars, columns, or lines). Figure 11-18
shows a chart with customized formatting
applied to each of these chart elements.
Chart Area Has
Solid Color Fill
Chart Wall Has
The Chart Styles buttons instantly recolor all the bars,
columns, lines, or slices in the active chart.
Formatting Your Chart Wall,
Area, and Gridlines
As is the case with your data points, you can
also easily edit the appearance of your chart wall
(the background, which is white, by default), the
chart area (also white by default, it’s the space
within the wall that contains your plotted data),
and gridlines (the horizontal and/or vertical
Every filled area of your chart—not just its bars,
columns, and slices—can be re-colored or filled
with a gradient, picture, texture, or pattern.