Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Line chart for churn rates of many items over time | Charts and Charting in Excel | |||
Activating a Chart object | Charts and Charting in Excel | |||
Line chart in Excel - trendline incomplete | Charts and Charting in Excel | |||
How to change Series Order in a Combination Chart? | Excel Discussion (Misc queries) | |||
Line chart - date line association gone mad! | Charts and Charting in Excel |