locked
Negative Value in Pie chart RRS feed

  • Question

  • Does anyone know why a negative value in Access Pie chart displays a positive percent instead of negative?


    How can I get Access Pie chart to give me the negative percent like Excel does without using Excel?


    If this post answered or helped you find the answer to your question, please mark it as such for other Forum users knowledge.

    Tuesday, February 27, 2018 6:14 PM

All replies

  • A negative % in a pie chart does not make sense, especially when you see that the negative % is totaled as a positive to give a 100% outcome. I never thought I'd ever say this but in this case the Access chart is right and the Excel chart is wrong. Even though DD is negative it still counts as part of the whole pie as a positive 23%.

    Bill Mosca
    www.thatlldoit.com
    http://tech.groups.yahoo.com/group/MS_Access_Professionals

    Tuesday, February 27, 2018 7:53 PM