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

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

NightWalker wrote:
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, Microsoft MVP - Excel
http://www.andypope.info