Making a chart that uses a secondary Y axis

N

NightWalker

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
 
A

Andy Pope

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2010 - Line Chart with Mulitiple Data Sets 1
Coordinate secondary y axis to primary y axis 2
Chart distorts secondary axis when the x-axis is logarithmic 5
Using the full width of an Excel chart with two Y-axes 2
Chart - Secondary Y-axis with different values/scale 2
Chart data scrunches to left when adding X axis date series 0
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Help with Bar-Line Chart..not aligned?? 1

Top