View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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