Microsoft Office Tutorials and References
In Depth Information
Creating a step chart
It’s critical that both value axes use the same scale. Excel’s automatic scaling
may cause the value axes to use different scales. In such a case, you will need
to adjust one or both of the axis scales manually.
Figure 8-18: This chart displays stacked columns in front of single columns.
Creating a step chart
A “step” chart is similar to a hybrid column/line chart. Figure 8-19 shows two charts
that use the data in columns A and B. The top chart is a standard line chart, and the
bottom chart is a column chart — modified to have a gap width of 0 and no border
colors. A typical step chart is similar to the column chart, but the columns are not visible.
Rather, a step chart depicts a single line with the data points connected at right angles.
Excel does not provide a step chart type, but you can create such a chart by using
an XY chart, along with X error bars and Y error bars. Figure 8-20 shows an
example of this type of chart. Column A and B contain the same data used in the
previous charts. In addition, this chart uses the data in columns C and D as the source for
the X error bars and Y error bars.
Refer to Chapter 5 for more information about using error bars.
Column C contains simple formulas that calculate the difference between the
dates in column A. For example, cell C3 contains this formula:
=A3-A2
Search JabSto ::




Custom Search