Microsoft Office Tutorials and References
In Depth Information
Emphasizing Periods of Time
Emphasizing Periods of Time
Some of your trending components may contain certain periods where a special event occurred,
causing an anomaly in the trending pattern. For instance, you may have an unusually large spike
or dip in the trend caused by some occurrence in your organization. Or maybe you need to mix
actual data with forecasts in your charting component. In such cases, it could be helpful to
emphasize specific periods in your trending with special formatting.
Formatting specific periods
Imagine you just created the chart component illustrated in Figure 8-24, and you want to explain the
spike in October. You could, of course, use a footnote somewhere, but that would force your audience
to look for an explanation elsewhere on your dashboard. Calling attention to an anomaly directly on
the chart helps give your audience context without the need to look away from the chart.
Figure 8-24: The spike in October warrants emphasis.
A simple solution is to format the data point for October to display in a different color and then add a
simple text box that explains the spike.
To format a single data point:
1. Click the data point once.
This places dots on all the data points in the series.
2. Click the data point again to ensure Excel knows you’re formatting only that one data point.
The dots disappear from all but the target data point.
3. Right-click and select Format Data Point.
The Format Data Point dialog box opens, as shown in Figure 8-25. The idea is to adjust the
formatting properties of the data point as you see fit.
The dialog box shown in Figure 8-25 is for a column chart. Different chart types have
different options in the Format Data Point dialog box. Nevertheless, the idea remains
the same in that you can adjust the properties in the Format Data Point dialog box to
change the formatting of a single data point.
Search JabSto ::

Custom Search