Displaying how much of each number I have in a set of data.

[dcolumbi]

I have a large series of data in my spreadsheet. Each cell is filled with a number ranging from 1-50. I'm simply trying to display how much of each number I have in my data. For example I would like a chart to show how many 1's appeared in the set of data, how many 2's and so on for all the numbers 1-50. Can anyone help? I feel like there's a simple way to do this but I can't seem to configure Excel to do so.
Thanks in advanced!!!

[daffodil11]

• Give your data a header
• Select your data
• Choose the Insert Tab, Select Pivot Table, hit Okay
• In the PivotTable Field List
  • Drag the header down to Row Labels
  • Drag the header down to the Value if it's not already there
• On the Chart, Right-Click Sum of Data, Move up to Summarize Values By, and Choose Count
• In the toolbar, select PivotTable Options, choose PivotChart, and pick a design you like and hit okay.

daffodil example for dcolumbi.xlsx

[njohnson10]

An easy way to do this would be to use a pivot table to summarize your data. Here is a simple example:

If Column A contains the data you want to summarize and the header is "Numbers", select all the data in column a and choose Insert-> Pivot Table. Once the pivot table is created you should see a field list. Drag the field "Numbers" to the Row Labels box, and then drag it again to the Values box. In the values box you will need to change the value field settings to Count (default with numerical values is Sum). This will create a summary of your data with counts for each number.

[njohnson10]

Dang, you beat me to it - and your post is much easier to read than mine... Touche

[daffodil11]

Sorry!

If it's any consolation, I am absolutely terrible at Pivot Tables, mentally stuck on Excel 2003.

[dcolumbi]

Thank you both! Just what I needed.
Much appreciated.