饼图中的负值 [英] Negative Value in Pie chart

问题描述

有谁知道为什么Access Pie图表中的负值显示正百分比而不是负值？

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

如何获取Access Pie图表如果不使用Excel，像Excel那样给出负百分比？

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.

推荐答案

饼图中的负百分比没有意义，特别是当您看到负百分比总计为正数以给出100％结果时。我从来没有想过我会说这个，但在这种情况下Access图表是正确的，Excel图表是错误的。即使是
虽然DD是负数，但它仍然算作整个馅饼的一部分为23％。

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%.

这篇关于饼图中的负值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！