0

I'm trying to create two lines on the same graph, with one being 'Line A' based on Data labeled 'A' and 'Line B' based on B.

The X-axis would be the date and would expand over time as more entries were added. The weight would be the Y-axis.

I can't seem to convince Google sheets to separate out the data based on the 'Name' column into two lines. Any help would be appreciated.

An example of data I'm trying to graph with two lines

0
  • your data should be in this format:

0


  • if this is not the option you can transform it with this formula:

=QUERY(A1:C, "select B,sum(C) where A is not null group by B,C pivot A", 1)

0

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.