Scatter Plot with 2 Y axes ?

[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

 

[Dan E]

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

 

[MWE]

Dan E: thanks. It works precisely as I wanted

MWE