Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Components That Show Trending
To change the vertical axis of a chart to logarithmic scaling, follow these steps:
1. Right-click the vertical axis and choose Format Axis. The Format Axis dialog box appears.
2. Expand the Axis Options section and place a check next to Logarithmic scale, as shown in
Figure 8-8: Setting the vertical axis to Logarithmic scale.
Logarithmic scales work only with positive numbers.
Applying creative label management
As trivial as it may sound, labeling can be one of the sticking points to creating effective trending
components. Trending charts tend to hold lots of data points, whose category axis labels take up lots of
room. Inundating users with a gaggle of data labels can definitely distract from the main message of
the chart. In this section, you find a few tips to help manage the labels in your trending components.
Abbreviating instead of changing alignment
Month names look and feel very long when you have to place them in a chart — especially when that
chart must fit on a dashboard. However, the solution isn’t to change their alignment, as shown in
Figure 8-9. Words that are placed on their sides inherently cause a reader to stop for a moment and
read the labels. This isn’t ideal when you want them to think about your data and not spend time
reading with their heads tilted.
Although it’s not always possible, the first option is always to keep your labels normally aligned. So
instead of jumping right to the alignment option to squeeze them in, try abbreviating the month
names. As you can see in Figure 8-9, even using the first letter of the month name is appropriate.