Excel count of counts

Question

If I have an Excel table as follow:

User1   1
User2 . 3
User3 . 2
User4 . 1
User5 . 1
User6 . 5
User7 . 2

I'm trying to graph the amount of similar values. In other words, I want to show how many "1s" there are in my list (3), how many "2s" (2) etc. Ideally in bar chart. For some reason I just can't figure it out today...

Answer 1

If you do not want to use PivotChart, you can do something like this:

1. Create an auxiliary table with unique values (use remove duplicates)
2. Create a bar chart with the Count values as a series with the Number values as the axis

Answer 2

If your data is like this:

Then you can create a PivotChart:

Create a PivotChart

And just take field USERS into X axis, and Count field into VALUES section. Something like this:

This should work for you.