Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
I want to turn this table (comes from an SQL database)
...into a line chart in Google Sheets that looks like this
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)
Required, but never shown