Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
secondary axis on chart | Excel Discussion (Misc queries) | |||
how can I have a secondary axis bar not covering the primary axis | Charts and Charting in Excel | |||
XY scatter and Bar chart - secondary axis misaligned | Charts and Charting in Excel | |||
Changing Secondary axis value units | Charts and Charting in Excel | |||
How do I change background colors between secondary y axis lines? | Charts and Charting in Excel |