Archive of Mr Excel Message Board
Check out Bill's new book on Charts and
Graphs for Microsoft Office Excel 2007
Back to Charting for Excel archive index
Back to archive home
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.
Re: Chart with stacked bars and lines
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.
-Ben
Re: Chart with stacked bars and lines
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.
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.