If you register for free, you will be able to post threads, vote on polls and lots more. If you have problems with the registration or logging in, please contact the administrator.
Does anyone know how to produce a second y axis in an excel line graph?
As the title says really. Does anyone know how to do it and if so how do you do it please?
Im struggling at the mo as i have one variable with large numbers (left y-axis) and another variable with low numbers (which i hope to put on the right y-axis). With all variables on the same y-axis it looks silly.
any help would be greatly appreciated!
11-22-2007, 04:42 PM
Does anyone know how to produce a second y axis in an excel line graph? Post #2
Both sets of y values will automatically be on the left hand axis. Right click on the low values, Format Data Series, go to Axis tab, tick secondary axis.
11-22-2007, 04:47 PM
Does anyone know how to produce a second y axis in an excel line graph? Post #3
next question: if the secondary y axis variables have negative values but the other doest how do you get the x axis to cross 0 on both y-axis and with the secondary y axis going to negative values but the primary y axis to not go any lower than 0?
11-22-2007, 04:48 PM
Does anyone know how to produce a second y axis in an excel line graph? Post #4
Does anyone know how to produce a second y axis in an excel line graph? 
Linear Mode
