1

How do you make a scatter graph with 2 Y axis (one on the left and one on the right)? I have 2 scatter graphs that I want to combine. I need to have 2 lines, both lines have the same dependent variable but have their own independent variable. Click the link "graph" below to get an idea of what I'm looking for.

(I'm using google sheets but I can also find a computer with Excel if needed)

graph

2

First I have all my data in Excel:

data

Then I create my scatter graph from that data:

scatter

From there, I will double click one of the data points of my 2nd series:enter image description here

It will open the series properties, there I select to send it to the secondary axis:enter image description here

And voilà, you have your 1st series on the primary axis and 2nd series on the secondary axis: enter image description here

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.