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
|
|||
|
|||
Assign data series to primary axis
Line chart:
Data Series: Altitude Oil Temp Oil Temp uses the primary vertical axis and Altitude the secondary. I want to add OAT (outside air temp), plotted against the primary axis. But when I add the new data series it uses the secondary axis and plots itself as a nearly straight horizontal line along the bottom of the chart. In this position I cannot seem to 'select' the series with the cursor. How can I add the OAT data series plotted against the primary axis. I have just upgraded to Excel 2007. -- Art |
#2
|
|||
|
|||
Assign data series to primary axis
Right click the added series, choose Format. In a visible position, I think
on the main tab, are radio buttons for Primary and Secondary. check Primary. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Art" wrote in message ... Line chart: Data Series: Altitude Oil Temp Oil Temp uses the primary vertical axis and Altitude the secondary. I want to add OAT (outside air temp), plotted against the primary axis. But when I add the new data series it uses the secondary axis and plots itself as a nearly straight horizontal line along the bottom of the chart. In this position I cannot seem to 'select' the series with the cursor. How can I add the OAT data series plotted against the primary axis. I have just upgraded to Excel 2007. -- Art |
Thread Tools | |
Display Modes | |
|
|