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.![Confused :confused: :confused:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
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:
![gender-weights.jpg](/board/proxy.php?image=https%3A%2F%2Fwww.dropbox.com%2Fs%2Fxc6wc1g6kjp6zsq%2Fgender-weights.jpg%3Fdl%3D0&hash=2812eb2e38af0f708b859c23aaf9f4eb)
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