Stacked bar chart w/second axis

[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

 

[Debra Dalgleish]

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