Excel Graphs

[Bruno_A]

This a very noobish question, but I simply can't remember how to do it and my google research isn't giving me anything useful, but basically, I want to make a chart (pie chart) with the highlighted data and display how many people have GTX 1060's, 1070's, etc. Can anyone help me here? 

 

This is what happens when I highlight the data and create a graph with it.

Spoiler

 

 

[HZapperz]

Steam already has this but in a listed format.

[Bruno_A]

Just now, HZapperz said:

Steam already has this but in a listed format.

I don't want to do this with GPU's, this is just an example I came up with.

[vanished]

I see you do not have a column for how many people have what card, just the card each person has.  There are two options:

1. make a column with the number of each type of card, or
2. use a pivot chart on the existing data

 

[Bruno_A]

Just now, Tech N Gamer said:

Select the data you want to put in a pie chart, then go to insert then click on the circle looking object. It then gives you a list. Choose whichever one you want.

 

3 minutes ago, bruny06 said:

This is what happens when I highlight the data and create a graph with it.

Did you see the image I uploaded? That's the graph that comes up if I do that.

[Bruno_A]

1 minute ago, Ryan_Vickers said:

I see you do not have a column for how many people have what card, just the card each person has.  There are two options:

1. make a column with the number of each type of card, or
2. use a pivot chart on the existing data

 

I will go with 2. Can you please explain that?  I did this once (not the pivot chart) and it was really easy, but I can't remember.

[vanished]

5 minutes ago, bruny06 said:

I will go with 2. Can you please explain that?  I did this once (not the pivot chart) and it was really easy, but I can't remember.

I do not recall exactly how they work but I will play around and edit this post once I have it

 

First make sure your data has headers like this:

(which I see yours does but it's often forgotten)

 

Then, select it and make a pivotchart (I'm sure you can find that in the menu)

 

Then drag the "card" thing into axis and values, like this

 

Then select the chart and make it a pie chart instead of a bar

 

Then, if necessary, use the "flip rows with columns" button and that should do it

[Bruno_A]

2 minutes ago, Ryan_Vickers said:

I do not recall exactly how they work but I will play around and edit this post once I have it

How about doing a countif?

[vanished]

2 minutes ago, bruny06 said:

How about doing a countif?

You could do that and then use the data generated with traditional charting, but the pivottable/pivotchart will do that "built in"

 

I've attached my sheet for a sample

 

Table.xlsx

[Bruno_A]

1 minute ago, Ryan_Vickers said:

You could do that and then use the data generated with traditional charting, but the pivottable/pivotchart will do that "built in"

 

I've attached my sheet for a sample

 

Table.xlsx

That's awesome, but how exactely did you set the pivot table? You created the table, then what?

 

[vanished]

Just now, bruny06 said:

That's awesome, but how exactely did you set the pivot table? You created the table, then what?

 

I tried to explain it above, what part is unclear?  I can go into more detail where needed

[Bruno_A]

9 minutes ago, Ryan_Vickers said:

I tried to explain it above, what part is unclear?  I can go into more detail where needed

Sorry, I didn't see your explanation before, but when I did, I was able to finish it. That was pretty useful. Thanks for your help, you're amazing. I did something like this years ago and I can't remember how I did it. maybe it wasn't a similar situation.

[vanished]

2 minutes ago, bruny06 said:

Sorry, I didn't see your explanation before, but when I did, I was able to finish it. That was pretty useful. Thanks for your help, you're amazing. I did something like this years ago and I can't remember how I did it. maybe it wasn't a similar situation.

Sounds good, glad I could help