ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Assign data series to primary axis (https://www.excelbanter.com/charts-charting-excel/223532-assign-data-series-primary-axis.html)

Art

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

Jon Peltier

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





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com