Combination stacked bar and line chart

Feb 28th, 2002, 09:16 AM

I need to create a combination stacked bar and line chart. I looked in the custom charts, but only found one that lets me do a simple bar chart-line chart combo. Anyone know how to do this? Also, how do I specify which data is to appear in the bars and which is to appear in the line format?

BREN · Mar 1st, 2002, 04:54 AM

Good Question. I would also be interested in getting the answer to this!

Searcher · Mar 1st, 2002, 10:41 AM

Use the Wizard and go all the way using the stacked bar chart. So you now have a chart with 3 results stacked. Say for Sales1 Sales2 and a TotalSales plan for the two of them together.
After the chart is made just click on the one section of a column you want changed so all the sections are highlighted (say TotalSales). Then right click to bring up the shortcut menu to to see "Chart Type" and select Line. You now have 2 stacks for your two sales areas and a line showing the plan for both of them together.
You can use this at anytime to change any chart series. You can also save this as a new custom chart.

edlaster · Oct 7th, 2003, 11:23 AM

Can the line series be tied to a second Y axis without losing the stacked column type for the other series?

fairwinds · Oct 7th, 2003, 11:33 AM

You will loose the stacked type when moving a serie to secondary axis, but you can change it back by right clicking on one of the series remaining on primary axis and change chart type to stacked.

Ekim · Oct 7th, 2003, 12:14 PM

Have a look at Jon Peltier’s site. You may pick up a few clues.

http://www.geocities.com/jonpeltier/....html#ComboCht

HTH

Mike

Oct 7th, 2003, 11:23 AM	#4
edlaster New Member Join Date: Oct 2003 Posts: 3	Re: Combination stacked bar and line chart Can the line series be tied to a second Y axis without losing the stacked column type for the other series?

Oct 7th, 2003, 11:33 AM	#5
fairwinds MrExcel MVP Join Date: May 2003 Posts: 8,631	Re: Combination stacked bar and line chart You will loose the stacked type when moving a serie to secondary axis, but you can change it back by right clicking on one of the series remaining on primary axis and change chart type to stacked. __________________ "Fair Winds and Following Seas"

Oct 7th, 2003, 12:14 PM	#6
Ekim Board Regular Join Date: Jun 2002 Location: Perth, Australia Posts: 1,416	Re: Combination stacked bar and line chart Have a look at Jon Peltier’s site. You may pick up a few clues. http://www.geocities.com/jonpeltier/....html#ComboCht HTH Mike

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 28th, 2002, 09:16 AM	#1
Guest Posts: n/a	I need to create a combination stacked bar and line chart. I looked in the custom charts, but only found one that lets me do a simple bar chart-line chart combo. Anyone know how to do this? Also, how do I specify which data is to appear in the bars and which is to appear in the line format?

Mar 1st, 2002, 04:54 AM	#2
BREN New Member Join Date: Feb 2002 Location: Ireland Posts: 1	Good Question. I would also be interested in getting the answer to this!

Mar 1st, 2002, 10:41 AM	#3
Searcher New Member Join Date: Feb 2002 Location: Jim C Posts: 1	Use the Wizard and go all the way using the stacked bar chart. So you now have a chart with 3 results stacked. Say for Sales1 Sales2 and a TotalSales plan for the two of them together. After the chart is made just click on the one section of a column you want changed so all the sections are highlighted (say TotalSales). Then right click to bring up the shortcut menu to to see "Chart Type" and select Line. You now have 2 stacks for your two sales areas and a line showing the plan for both of them together. You can use this at anytime to change any chart series. You can also save this as a new custom chart.