+ Reply to Thread
Results 1 to 6 of 6

Pie chart percentage is incorrect?

  1. #1
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Pie chart percentage is incorrect?

    The % in the pie chart is incorrect - I have attached a sample file.

    Thanks in advance.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Pie chart percentage is incorrect?

    Your approach was mathematically incorrect. The pie chart should show wages and OTHER costs... not total costs. See file.
    Attached Files Attached Files
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Pie chart percentage is incorrect?

    If all costs =112751400.77, please try Other costs = all costs - Wages = 112751400.77-B2.
    Please try % Wages = %Wages / all costs = Wages / (Wages + Other costs) = B2/(B2+B3) = 54%
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    06-11-2009
    Location
    Cape Town
    MS-Off Ver
    Microsoft 365
    Posts
    854

    Re: Pie chart percentage is incorrect?

    Apologies for that & thank you!

  5. #5
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,055

    Re: Pie chart percentage is incorrect?

    You're welcome.



    It would be very nice if you were to just click the Add Reputation button at the foot of any of the posts of members who helped you reach a solution.

    Finally, if that takes care of your original question, please click on "Thread Tools" from the menu link (just above the first post in the thread) and mark this thread as SOLVED.

  6. #6
    Forum Guru HansDouwe's Avatar
    Join Date
    06-21-2022
    Location
    Nederland
    MS-Off Ver
    365 V2403 (Build 17330.20000)
    Posts
    6,433

    Re: Pie chart percentage is incorrect?

    No apologies needed. Glad to have helped and thanks for the feedback.

+ 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. [SOLVED] DAX measure for percentage showing incorrect result
    By Dicken in forum Office 365
    Replies: 3
    Last Post: 06-05-2022, 05:10 AM
  2. [SOLVED] Worksheet Shows Incorrect Calculation When % Percentage Is Added
    By klownzold in forum Excel General
    Replies: 12
    Last Post: 10-08-2021, 08:24 AM
  3. Percentage Vlookup Returning Error / Incorrect Values
    By piepod in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-14-2021, 09:55 AM
  4. [SOLVED] Pie Chart Percentage incorrect
    By ocnuybear in forum Excel General
    Replies: 2
    Last Post: 10-29-2019, 01:48 AM
  5. Pie Chart showing incorrect percentage in label
    By excelentis in forum Excel General
    Replies: 1
    Last Post: 12-12-2018, 02:57 AM
  6. Pie Chart Incorrect?
    By watson150 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-12-2016, 06:35 PM
  7. [SOLVED] Percentage Incorrect In Pie Chart
    By Gladys in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-13-2006, 02:25 PM

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