Microsoft Office Tutorials and References
In Depth Information
Creating a timeline
The data for the chart is in A2:B13. The axes in this chart are actually additional
XY data series, formatted to look like axes (the “real” axes are hidden). Data that
generates the vertical axis is in A16:B27. Data for the horizontal axis is in C16:D27.
Both of these are XY series that display lines and markers. For details on using
dummy axes, refer to “Using a Dummy Axis,” earlier in this chapter.
Creating a timeline
Figure 8-37 shows an XY chart, set up to display a timeline of events. The chart
uses the data in columns A and B, and the series uses Y error bars to connect each
marker to the timeline (the X value axis). The text consists of customized data
labels. The Y value axis for the chart is hidden, but it is set to display Values in
reverse order so that the earliest events display higher in the vertical dimension.
This type of chart is limited to relatively small amounts of text — otherwise, the
data labels wrap and the text may be obscured.
Figure 8-37: This XY chart uses data labels and Y error bars to connect its
points to the X value axis.
Search JabSto ::




Custom Search