Microsoft Office Tutorials and References
In Depth Information
Chapter 8: Components That Show Trending
One solution is to show the trending vertically using a bar chart. (See Figure 8-11.) With a bar chart,
you have room to label the data points and keep the chart to a reasonable size. This isn’t something
to aspire to, however. Trending vertically isn’t as intuitive and may not convey your information in a
very readable form. Nevertheless, this solution can prove to be just the workaround you need when
the horizontal view proves to be impractical.
Figure 8-11: A bar chart can prove to be effective when trending days extending to 30 or more data points.
Nesting labels for clarity
Often, the data you’re trying to chart has multiple time dimensions. In these cases, you can call out
these dimensions by nesting your labels. Figure 8-12 demonstrates how including a year column
next to the month labels clearly partitions each year’s data. You simply include the year column
when identifying the data source for your chart.
Figure 8-12: Excel is smart enough to recognize and plot multiple layers of labels.