Stacked bar chart w/second axis

  • Thread starter Thread starter tmtemple
  • Start date Start date
T

tmtemple

Is it possible to make a stacked bar chart AND have two line graphs on
second axis? (all on the same chart)

I'm working in Excel2000 and don't see a way to do it.

Thanks
 
Create a stacked chart from all the data
Right-click on one of the series, and choose Chart Type
Select a Line Chart, click OK
Select the other series that you want as a line, and press the F4 key
(this will repeat the previous action, and change the chart type)
Right click one of the lines, and choose Format Data Series
Select the Axis tab, anc choose Secondary Axis
Select the other line, and press the F4 key
 
Back
Top