View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
NightWalker NightWalker is offline
external usenet poster
 
Posts: 1
Default Making a chart that uses a secondary Y axis

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