CODEWITHSUNDEEP
excelcharts
zBernie
zBernie

Reputation: 97

Excel how summarize values in

I have a column of data like the one below under "DATA". How can I create a chart which which would summarize each unique value like:

CPU Utilization Alert 6
Free Memory Alert 1
System Uptime Alert 2

DATA:

CPU Utilization Alert 
CPU Utilization Alert 
Free Memory Alert 
System Uptime Alert 
CPU Utilization Alert 
CPU Utilization Alert 
CPU Utilization Alert 
System Uptime Alert 
CPU Utilization Alert

-Thanks

Upvotes: 0

Views: 106

Answers (2)

Terry W
Terry W

Reputation: 3257

I agree with Scott that using Pivot Table is the fastest approach especially when you only after a quick summary of the counts per data type.

If you literately want a chart, you can highlight your data and insert a Pivot Chart, which will ask you to set up a pivot table (as demonstrated by Scott), and then let you display the result in a chart. The chart I used is a Pie Chart as demonstrated below:

Demo

Upvotes: 1

Scott Craner
Scott Craner

Reputation: 152605

Use a pivot table, Putting the data column in both the Rows and the Values:

enter image description here

Upvotes: 1

Related Questions