Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
Barb
 
Posts: n/a
Default Adding series, this time with a 2 axes line chart

I working with 2 axes line chart. My x-axis is month/year and my first y
axis is instrument result for Hospital A, my second y axis is outside
temperature. The chart looks great. Now I want to add addional lines for
other hospitals. When I click on add series and add the data for Hospital B,
it plotts it correctly using the y axis for instument result, but my Hospital
A data suddenly becomes a straight line as the graph is now trying to plot
the instrument results for Hospital A vs. the wrong y axis (temperature). I
have no idea how to indicate when I am adding data which y axis it is to use.
There will be only 1 plot vs. the temperature axis, all the other lines
should be plotted against the y axis for results.
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default Adding series, this time with a 2 axes line chart

Hi,

I think once there is a secondary axis in use new data trys to use it
and I can not find anyway to specify new data uses the primary axis.

To change the series back to the primary axis double click the series
and on the Axis tab change the setting.

Cheers
Andy

Barb wrote:
I working with 2 axes line chart. My x-axis is month/year and my first y
axis is instrument result for Hospital A, my second y axis is outside
temperature. The chart looks great. Now I want to add addional lines for
other hospitals. When I click on add series and add the data for Hospital B,
it plotts it correctly using the y axis for instument result, but my Hospital
A data suddenly becomes a straight line as the graph is now trying to plot
the instrument results for Hospital A vs. the wrong y axis (temperature). I
have no idea how to indicate when I am adding data which y axis it is to use.
There will be only 1 plot vs. the temperature axis, all the other lines
should be plotted against the y axis for results.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Line chart for churn rates of many items over time Whoops Charts and Charting in Excel 3 August 25th 05 07:26 PM
Activating a Chart object Hari Prasadh Charts and Charting in Excel 6 August 2nd 05 07:22 PM
Line chart in Excel - trendline incomplete [email protected] Charts and Charting in Excel 7 May 13th 05 01:21 PM
How to change Series Order in a Combination Chart? vrk1 Excel Discussion (Misc queries) 0 March 31st 05 11:19 PM
Line chart - date line association gone mad! Johannes Czernin Charts and Charting in Excel 5 January 17th 05 09:48 PM


All times are GMT +1. The time now is 12:23 AM.

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

About Us

"It's about Microsoft Excel"