CODEWITHSUNDEEP
google-sheets
James A
James A

Reputation: 73

Google Sheets Pie Chart

not sure if this is the right place to post this, but here goes.

Say I have the following column of data in google sheets: enter image description here

And say that I wanted to continuously add to the column as I go and listen to more artists. How can I have a pie chart which represents which artists I listen to the most, and have it automatically update with each new entry I add the column? Thanks in advance.

Upvotes: 1

Views: 449

Answers (3)

player0
player0

Reputation: 1

paste this formula into G1 cell and create the chart from there:

=QUERY(F1:F, "select F,count(F) 
              where F is not null 
              group by F 
              label count(F)''", 0)

Upvotes: 2

GregP
GregP

Reputation: 153

What your asking for is considered a "Group By" in SQL. Google Sheets has these capabilities. See here for a full explanation (scroll down to Group By section).

Snippet from the link:

Upvotes: 0

Cdub
Cdub

Reputation: 34

In google sheets, this can be solved in three columns:

Column C: your list of artists, input as you said
Column B: =Countif(C:C,A1)
Column A: =UNIQUE(C:C)

The pie chart should check column A for labels, and column B for its series.

You will have to drag down the equation in Column B to be as long or linger than your list. Also, this is case sensitive, but you should be able to deal with that yourself.

Upvotes: 0

Related Questions