Making a chart that uses a secondary Y axis

[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

 

[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