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