Microsoft Office Tutorials and References
In Depth Information
Following are a few key points regarding this chart:
The chart is actually a combination chart that combines a standard line
chart with an XY chart.
The “real” value axis is hidden. In its place is an XY series that is formatted
to look like an axis.
The data for the XY series is stored in A14:B18. The Y values represent
the scores for each letter grade category. For example, an F is 0–19, a D is
20–39, and so on.
The axis labels (the letters A–F) are custom data labels for the XY series.
To get a better feel for how a dummy value axis is set up, refer to Figure 8-13.
This is a standard XY chart, with the data points connected by lines, and series
markers set to display a horizontal tick. It uses the five data points specified in
A2:B6. Because each X value is the same (1), the series displays as a vertical line.
This XY series uses custom data labels to identify each “tick.” As you can see, this
data series look very much like a vertical axis.
Figure 8-13: This XY series displays as a vertical line with tick marks
and uses custom data labels.
Following are the steps required to create the line chart pictured at the beginning of
this section.
1. Select the data in A1:B11 and create a standard line chart. Delete the legend.
2. Select A15:B19 and choose Edit
3. Select the chart and choose Edit
Paste Special. Specify New series, Values
(Y) in Columns, and Category (X Labels) in First Column. Doing so adds a
new line series to the chart.
Search JabSto ::

Custom Search