How to make a pie chart with one column of data?

Hi, I am trying to create a basic list of all the games I own and what console they are on. I created a table and the top row is the header with the 1st column being the name of the game and the 2nd column being the console it is on.


Now all I want to do is create a pie chart of the amount of games I have on each console but when I create a chart of column ‘B’ it just shows as one big blob of the same color. Is there a way to have it sort through the column and every time it sees PS4 or Xbox One it can automatically change the pie chart accordingly?

MacBook Pro TouchBar and Touch ID, macOS Sierra (10.12.5)

Posted on Jun 28, 2017 7:32 AM

Reply
2 replies

Jun 28, 2017 8:17 AM in response to MidnightTundra

MidnightTundra wrote:



Now all I want to do is create a pie chart of the amount of games I have on each console


Hi,


You can try something like this:


User uploaded file



The formula in B2 of the counts table is =COUNTIF(A,A2)


The idea is to use COUNTIF to find how many games on each console. You first list the name of each console in column A of a separate table.


Make sure column A is defined as a Header Row.


SG

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

How to make a pie chart with one column of data?

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.