+ Reply to Thread
Results 1 to 9 of 9

Percentage and pie chart help

  1. #1
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Percentage and pie chart help

    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

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Percentage and pie chart help

    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

  3. #3
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Re: Percentage and pie chart help

    Here is an example though there is no A's on it though my other work sheets have A's.

    Thank you again
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Percentage and pie chart help

    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

  5. #5
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Re: Percentage and pie chart help

    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?

  6. #6
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Re: Percentage and pie chart help

    I fixed this by adding $ to the formula,

    Thank you again Pete,
    Anthony

  7. #7
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    24,604

    Re: Percentage and pie chart help

    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

  8. #8
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Re: Percentage and pie chart help

    I will do that though the percentages are note working out correctly, trying to solve it at the moment.

  9. #9
    Registered User
    Join Date
    11-24-2016
    Location
    England
    MS-Off Ver
    Professional Plus 2013
    Posts
    6

    Re: Percentage and pie chart help

    My bad sorted, sorry

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Pie Chart Given a Percentage
    By cards18 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 11-01-2016, 12:25 PM
  2. Replies: 1
    Last Post: 11-20-2015, 12:50 PM
  3. Showing a percentage of a percentage in pie chart
    By jimbob76 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-17-2009, 09:52 AM
  4. Replies: 5
    Last Post: 10-30-2007, 11:16 AM
  5. Percentage Bar Chart
    By jaredino in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-19-2007, 07:33 AM
  6. Bar Chart Percentage
    By qwerty4546 in forum Excel General
    Replies: 1
    Last Post: 12-21-2005, 08:25 PM
  7. Replies: 1
    Last Post: 10-28-2005, 01:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1