Reputation: 1626
I'm trying to figure out how to create a Google scatter chart visualization for the following dataset:
Person Week Production
------ ---- ----------
Bob 1 3
Bob 2 3
Bob 3 6
Bob 4 2
Bob 5 0
Bob 6 4
Sue 1 7
Sue 3 6
Sue 4 8
So what I would like to see is Week along the hAxis and Production along the vAxis. Each person, live data could be more than 2 people, would have their own plot point color and show up in the chart legend.
Can anyone show me how to do this? I find the Google documentation/examples lacking for the Scatter Chart
Upvotes: 0
Views: 59
Reputation: 1394
Here you go:
You'll note that I've inserted null
s where Sue didn't have data.
Upvotes: 1