I have the following columns of data which are pulled from a form:
I would like to create a scatter chart showing the following:
Gender on the Vertical (aggregated, so that are only two values)
Left AND Right values horizontally (two colors)
Here's a hand drawn example:
https://www.dropbox.com/s/xc6wc1g6kjp6zsq/gender-weights.jpg?dl=0
The goal is to ultimately demonstrate that Male values for Column A & B are greater than Female.
Can someone guide me in how to make this happen please?
I've tried and tried and just can't get everything to connect correctly.
Thank you, Decli
A Left (number)
B Right (number)
C DNA Gender (text M F)
D Age group (number)
E Height (number)
B Right (number)
C DNA Gender (text M F)
D Age group (number)
E Height (number)
I would like to create a scatter chart showing the following:
Gender on the Vertical (aggregated, so that are only two values)
Left AND Right values horizontally (two colors)
Here's a hand drawn example:

https://www.dropbox.com/s/xc6wc1g6kjp6zsq/gender-weights.jpg?dl=0
The goal is to ultimately demonstrate that Male values for Column A & B are greater than Female.
Can someone guide me in how to make this happen please?
I've tried and tried and just can't get everything to connect correctly.

Thank you, Decli