If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Y2 axis
How do I install a Y2 axis into a 2D line graph in ex cel office 07 ... seems
there is no easy way ....ms help suggests choosing a compatible graph but neglects to tell us which is compatible ... so sticking with a simple 2D line graph I am up a blind alley going no where fast ... thanks in advance of rany asisstance |
#2
|
|||
|
|||
Y2 axis
Hi,
To have 2 Y axes you need a minimum of 2 series of data. If you just want dual axis labelling then the second set of data can be a repeat of the first. Otherwise create a chart with both series on the primary axis. Select one of the series to move to the secondary y axis. Format dialog Series Options Secondary axis. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Tyre Anser" wrote in message ... How do I install a Y2 axis into a 2D line graph in ex cel office 07 ... seems there is no easy way ....ms help suggests choosing a compatible graph but neglects to tell us which is compatible ... so sticking with a simple 2D line graph I am up a blind alley going no where fast ... thanks in advance of rany asisstance |
Thread Tools | |
Display Modes | |
|
|