Microsoft Office Tutorials and References
In Depth Information
Emphasizing Periods of Time
Figure 8-27: Use a simple line to mark particular events along a trend.
Although there are lots of fancy ways to create this effect, you will rarely need to get any fancier than
manually drawing a line yourself. To draw a dividing line inside a chart, take the following steps:
1. Click the chart to select it.
2. Select the Insert tab on the Ribbon and click the Shapes drop-down command.
3. Select the line shape, go to your chart, and draw the line where you want it.
4. Right-click your newly drawn line and select Format Shape.
5. Use the Format Shape dialog box to format your line’s color, thickness, and style.
Representing forecasts in your trending components
It’s common to be asked to show both actual data and forecast as a single trending component.
When you do show the two together, you want to ensure that your audience can clearly distinguish
where actual data ends and where forecasting begins. Take a look at Figure 8-28.
Figure 8-28: You can easily see where sales trending ends and forecast trending begins.
The best way to achieve this effect is to start with a data structure similar to the one shown in
Figure 8-29. As you can see, sales and forecasts are in separate columns so that when charted,
you get two distinct data series. Also note that the value in cell B14 is actually a formula referencing
C14. This value serves to ensure a continuous trend line (with no gaps) when the two data series
are charted together.