Charting

genplan · Mar 21st, 2002, 07:49 AM

I am trying to create a stacked bar chart with 2 line charts on top of the bars. I have no idea how to do this?

Anne Troy · Mar 21st, 2002, 08:02 AM

Create a stacked bar for all 4 data series. Right-click one of the series that you want to change and choose Chart Type. Change it to line. Do the same to the 2nd series that you want a lines.

Mark W. · Mar 21st, 2002, 08:03 AM

Create a Stacked Column chart for all series. Make series that you want to be the line formatted series the 2 highest series. Change the chart type of the 2 highest series to Line. Add a 2nd Y-axis and assign the 2 highest series to this axis if necessary.

Mar 21st, 2002, 08:02 AM	#2
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	Create a stacked bar for all 4 data series. Right-click one of the series that you want to change and choose Chart Type. Change it to line. Do the same to the 2nd series that you want a lines. __________________ ~Anne Troy

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

Mar 21st, 2002, 07:49 AM	#1
genplan New Member Join Date: Mar 2002 Posts: 3	I am trying to create a stacked bar chart with 2 line charts on top of the bars. I have no idea how to do this?

Mar 21st, 2002, 08:03 AM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	Create a Stacked Column chart for all series. Make series that you want to be the line formatted series the 2 highest series. Change the chart type of the 2 highest series to Line. Add a 2nd Y-axis and assign the 2 highest series to this axis if necessary.