MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Chart with stacked bars and lines

Posted by Brian on November 16, 2000 2:12 PM

I'm looking for a way to create a chart with most of
the ranges consisting of stacked bars and another range
which is a line. I can easily get a regular bar with
a line, but not a stacked bar.

Posted by Ben O. on November 16, 2000 2:49 PM

When you orginally create the chart, include the series that will eventually be a line as a regular series in the stacked bar chart. Once the chart is created, right-click on the series that will be the line, select Chart Type, and then select line chart.

You might want to use a Stacked Column chart instead of a Stacked Bar chart though, since a column chart and a line chart can use the same axis labels, whereas added a line to a Stacked bar chart creates additional axis labels on the right and top of the chart, and the line won't go the same way as the bars.


Posted by Brad O. on April 10, 2005 2:31 PM

For this to work, the checkbox for "Apply to Selection" (under options) has to be checked. It took me a while to figure this out because it is not in an obvious place.