Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / December 2003

Tip: Looking for answers? Try searching our database.

Stacked Charts with price on 2nd axis

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Tracy Coakley - 18 Dec 2003 22:31 GMT
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?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.