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