Microsoft Office Tutorials and References
In Depth Information
Color-Coordinating Your Data Using Chart Styles
Also notice that you can change the maximum and minimum values at either end of the
scale. Thus, if you click the Fixed radio button alongside Minimum (it’s called “fixed”
because you’ve chosen and fixed that value, overriding Excel’s automatic decision) and
type , your chart will look like Figure 6–33. 40
Figure 6–33. Raising the bottom line: A new minimum chart value
OK—why would you want to do this? The fact is that many charts adopt a minimum
value greater than 0, because the values being charted aren’t likely to go anywhere near
that numerical point. Think about the stock market charts you’ve seen; they’ll practically
never start at 0, because the Dow Jones index is up there in the five figures (at least it is
now), and a daily change of 100 points looks far more striking when the chart minimum
is set at 10,000 than it would if it were 0. On the other hand, establishing a new
minimum will change the visual relation of the bars to one another. Brian’s 93 will seem
even more masterly as a result. You need to think about how, or if, that distortion will
impact your audience.
Color-Coordinating Your Data Using Chart Styles
Remember I stated a while back that virtually every element of a chart can be changed,
and changing chart colors is probably one of the principal changes you’re likely to make.
Excel gives you plenty of opportunities to fine-tune your chart, one element at a time.
But you can also revamp the appearance of a chart in one fell swoop with the Styles
option, a very easy-to-apply feature that recolors all the chart data series and,
depending on the option you choose, the plot area too. Just click Chart Tools, and click
Chart Styles on the Design tab (click the More drop-down arrow—the third of the three
drop-down arrows) to reveal all the selections (see Figure 6–34).
Search JabSto ::

Custom Search