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.