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. |
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 |
All times are GMT +1. The time now is 10:11 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com