I want to turn this table (comes from an SQL database)

enter image description here

...into a line chart in Google Sheets that looks like this

1 Answer 1

  • first you will need to pivot out series with QUERY formula and then plot the chart

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


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.