Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Art Art is offline
external usenet poster
 
Posts: 587
Default 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   Report Post  
Posted to microsoft.public.excel.charting
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Combination chart: primary data labels obscure line series on secondary axis Uhl Charts and Charting in Excel 3 December 12th 06 08:52 PM
2nd Axes - primary series data of only 1 series disappears! cheriw Charts and Charting in Excel 1 February 23rd 06 12:32 AM
In a 2 Y-Axis chart, how do I assign data ranges to an axis? Claire4Golf Charts and Charting in Excel 1 September 28th 05 07:52 PM
Primary/Secondary Axis series count raydenl Charts and Charting in Excel 1 July 28th 05 08:36 AM
Excel Charts - Data being Plotted beyond Primary X-Axis Scale Yvonne Fochesato Charts and Charting in Excel 1 May 1st 05 03:36 AM


All times are GMT +1. The time now is 07:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"