You are reading a single comment by @NotThamesWater and its replies.
Click here to read the full conversation.
London Fixed Gear and Single-Speed is a community of predominantly fixed gear and single-speed cyclists in and around London, UK.
This site is supported almost exclusively by donations. Please consider donating a small amount regularly.
@NotThamesWater
I have a quick & dirty way to do this
Can't upload the file or image, but:
Scatter plot
Series data:
Series name=Sheet1!A2
Series X values=Sheet1!B1:K1
Series Y values=Sheet1!B2:K2
Where the values in
A2 = "Antibacterial Soap"
B1:K1 = all have "1"
B2:K2 = your observation data
Other series:
Series name=Sheet1!A5 = "Normal Soap"
Series X values=Sheet1!B4:K4 = "2" for all cells
Series Y values=Sheet1!B4:K4 = observation data