Scatter Plot with 2 Y axes ?

  • Thread starter Thread starter MWE
  • Start date Start date
M

MWE

I wish to plot two Y variables against the same X as a *scatter* plo
but would also like each Y scaled to its own Y axis (like the categor
plot with 2 Y axes). There does not appear to be a standard o
advanced "built-in" chart type for this? Am I missing something? Ca
Excel be tricked into providing what I want?

Thank
 
MWE,

- Make an XY (scatter) plot with your data ie(2 series Y1 v X and Y2 v X).
- In your chart right click on one of the series and choose Format Data Series.
- Under the Axis tab select "Secondary Axis" for the "Plot series on" option.
- Hit OK
- Scale both axis to the desired values.

Dan E
 
Back
Top