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