Help producing chart from data

[ohdobehave]

Hi all i hope someone can help. I've looked through the forum and cannot find a similar thread.

I have a table which contains peoples details and one of the rows is Ethnic origin. I have a coding system for this e.g. 1 = White british 2 = White Irish 3 = White Other etc etc.

I want to be able to produce a pie chart so it shows how many people are from each origin but it just uses the numbers i have entered e.g. if i have entered code 7 into column 2 its makes the value 7, where as i want to use it as if i have entered the code 7 12 times along that row then i want it to show the value 12.

How i hope this makes sense to people

[oldchippy]

Hi,

Something like this?

[sweep]

Hi,

You need to create a second table to produce the figures you want in the pie chart.

Assuming your raw data (containing the inputs you describe) are in row 5, the following formula will count the number of occurences of each input

=countif(5:5,"=1")
=countif(5:5,"=2")
=countif(5:5,"=3")
=countif(5:5,"=4") etc.

Use the results from these formula to plot your chart