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.

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