Excel chart question

[ripvanfish]

This might be a very simple question, but it is frustrating me. I want to make a chart that captures a series of data like this:

a
a
b
e
f
a
b

and produce a chart showing the quantity of each value (a=3, b=2, e=1,f=1)

Any tips on how to do this? Thanks!

 

[bandit600]

Create your chart, be it a bar, pie or whatever. Right click on the chart and choose format data series. On the data labels tab choose show values.

bandit600

 

[HobbitK]

The only way I can think of is to insert a CountIf function for each letter you want to chart. you can do that on a column you hide or a different sheet if that matters, then make your chart based on those. If you name the column that your letters are in, then the formula can keep growing up to the max length of a column in Excel. Since you are dealing with text, make sure you use enclose the search criteria in quotes .. "a" not a.

 

[xlbo]

Create a pivot table using your 1 column data range
you will need a header so lets say it is "Letter"

Go thru the wizard till you get to the diagram of where to put the fields
Drag "Letter" into the ROW area and then drag it into the DATA area

double click on "Letter" in the data area and check that it is set to COUNT
Create your chart based on this pivot table Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[ripvanfish]

Thanks so much...the pivot table works great!!!!