Stacked Charts with price on 2nd axis

[Tracy Coakley]

I'm trying to create a chart that is stacked - with a price
line on a second y axis

I am trying to show total volume wit
volume used and volume remaining in one stack and then on top of that I want a price line on the second Y axis

I see a Line-Column on 2 axis but I need a Line-Stacked Column on 2 axis

Any ideas

 

[Tushar Mehta]

Create a stacked chart with all the data including price. Then, select
the price series on the chart. Select Chart | Chart Type... and select
the kind of line you want to use. Double-click the line series and
from the Axis tab select Secondary.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Hi Tracy -

Skip the "Custom Built In" chart types. It's a great oxymoron, but the
choices aren't all that flexible.

Create a chart with all series as stacked column types. Right click on
the Price series, choose Chart Type from the pop up menu, and select a
line type for this series. Now double click on the new line series, and
on the Axis tab, click Secondary.

There, your first custom combination chart type! Welcome to Excel charting.

- Jon