Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |