Microsoft Office Tutorials and References
In Depth Information
A bar-line combination chart
Although the chart is an XY chart, the series line and series markers are both
hidden (formatted as None). Therefore, the line is composed entirely from the X
error bars (column C) and Y error bars (Column D). The error bars are formatted as
heavy lines, with no crosses at their ends.
A bar-line combination chart
It’s easy to create a column-line combination chart. You either can use the custom
chart type in the Chart Wizard, or you can start with a standard column chart and
change one of the series to a line chart type. Figure 8-21 shows a simple example.
The columns represent sales, and the line depicts projected sales. But if you’ve ever
needed to create a combination bar-line chart, you may have concluded that Excel
does not allow it.
Figure 8-21: A column-line combination chart
is easy to create.
Technically, Excel does not support a combination bar-line chart. The category
axis for a bar chart extends in the vertical direction. The category axis for a line
chart, on the other hand, must always be the horizontal axis. The solution is to use
an XY chart type instead of the line chart type. Figure 8-22 shows an example.
To create this chart:
1. Create a standard bar chart using the data in A1:A13.
2. Select range D1:E13 and choose Edit
3. Activate the chart and choose Edit
Paste Special. Choose New series,
Values (Y) in Columns, Series Names in First Row, and Category (X Labels)
in First Column. Note that the data is arranged opposite of what you
might expect: The x values consist of the Project Sales amounts, and the y
values consist of consecutive integers.
4. Select the newly added series (it will be a bar series) and access the
Format Data Series dialog box. In the Axis tab, select Secondary axis.
Search JabSto ::

Custom Search