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 / October 2006

Tip: Looking for answers? Try searching our database.

Making a chart that uses a secondary Y axis

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
NightWalker - 10 Oct 2006 03:26 GMT
Hi, I'm having trouble creating a chart that has three types of data,
perhaps I'd better explain.

I'm trying to chart the progress of a project over time that's simple
enough, but I want to add to the chart the amount of estimated hours
each part of the project is going to take, so my chart should be
something like Y1 axis = % completed, X axis = name of subproject, Y2
axis = estimated hours for subproject.

I have gotten as far as doing this in a line chart but I want to make
the Y2 axis a bar chart that extends behind the lines for the
subprojects, can anyone tell me how I can change the chart type for
just this series of data?

TIA

Ivan Milanez Castellanos
Andy Pope - 10 Oct 2006 08:37 GMT
Hi,

Select the series you want to change and then right click and pick chart
type from the context menu. Or with the series selected use the menu
Chart > Chart Type.

Cheers
Andy

> Hi, I'm having trouble creating a chart that has three types of data,
> perhaps I'd better explain.
[quoted text clipped - 13 lines]
>
> Ivan Milanez Castellanos

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

 
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.