Hi,
I have a column of letters ranging from A-D and need to find out what percentage of the total numbers are A's, B's, C's & D's then I would like to display these in a pie chart.
Can some one help me please?
Thank you
Hi,
I have a column of letters ranging from A-D and need to find out what percentage of the total numbers are A's, B's, C's & D's then I would like to display these in a pie chart.
Can some one help me please?
Thank you
It would help if you attached a sample Excel workbook.
To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.
Pete
Here is an example though there is no A's on it though my other work sheets have A's.
Thank you again
List the unique letters in column C, so that you have B, C, D, I, W in C1:C5.
Then you can have this formula in D1:
=COUNTIF(A:A,C1)
Copy that down to D5 to get the count of each letter. If you want to get the percentages, you can use this formula in E1:
=D1/SUM(D:D)
Format as percentage, then copy down.
If you want a pie chart, highlight the cells C1:D5, click on the Insert tab of the ribbon, then click on the symbol for Pie.
Hope this helps.
Pete
Thank you Pete,
This works sort of though when I copy the formula down by one it move the range and criteria down by one, this can be fixed manually I know but do you know how to stop this from moving?
I fixed this by adding $ to the formula,
Thank you again Pete,
Anthony
Glad you got it working, though I'm not sure why you would not want C1 to change to C2 in cell D2.
If that takes care of your original question, please take a moment to select Thread Tools from the menu above your first post and mark this thread as SOLVED.
Also, since you are relatively new to the forum, you might like to know that you can directly thank those who have helped you by clicking on the small "star" icon located in the lower left corner of a post that you have found to be helpful (not just in this thread - for any post that has helped you). This also adds to the reputation of the poster (the small green bars in the poster's profile).
Pete
I will do that though the percentages are note working out correctly, trying to solve it at the moment.
My bad sorted, sorry
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks