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 - 19 Dec 2003 13:44 GMT
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.

Signature
Regards,
Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
> I'm trying to create a chart that is stacked - with a price
> line on a second y axis.
[quoted text clipped - 5 lines]
>
> Any ideas?
Jon Peltier - 19 Dec 2003 13:52 GMT
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
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______
> I'm trying to create a chart that is stacked - with a price
> line on a second y axis.
[quoted text clipped - 5 lines]
>
> Any ideas?