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
Hi,
Something like this?
oldchippy
-------------
If you are happy with the help you have received, please click the blue scales icon in the blue bar of the post.
Click here >>> Top Excel links for beginners to Experts
Forum Rules >>>Please don't forget to read these
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
Sarcasm - because beating the **** out of someone is illegal.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks