Assign data series to primary axis

A

Art

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.
 
J

Jon Peltier

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top