# Help me understand charting percentages and negative values
**URL:** https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500
**Category:** Ask for Help
**Created:** [February 11, 2020, 2:16pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500 "2020-02-11T14:16:00Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 2:16pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/1 "2020-02-11T14:16:00Z")
Folks,
My chart when it has negative values is left unidentified, it doesn’t select.
How to solve? 
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 2:36pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/2 "2020-02-11T14:36:43Z")
What do you mean by unidentified? It looks fine to me.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 2:38pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/3 "2020-02-11T14:38:53Z")
when it has negative values it makes a single Chart.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 2:40pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/4 "2020-02-11T14:40:45Z")
here with positive values…see the difference
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 2:44pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/5 "2020-02-11T14:44:38Z")
Well, you can’t eat a negative amount of pie or doughnuts. 😉 . I think a bar chart might be better for your case. A pie or doughnut chart determines how much out of 100 percent each piece takes out of the total value. Your total value is 298.902 and you have one piece of the pie that’s 633. That’s over 100% of the pie. You can’t eat more or than there is to eat. 😉
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 2:50pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/6 "2020-02-11T14:50:56Z")
note that it has a “positive” value where it should be “negative”. It is not showing reliable values.
case: I am showing the total cost of an XYZ project, it can be negative or positive … but here people will not be able to visually identify which one has “problem”
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 2:56pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/7 "2020-02-11T14:56:16Z")
Which one is showing positive when it should be negative? I’m not seeing the problem.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 2:58pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/8 "2020-02-11T14:58:08Z")
the second is up, but it should be down, as it is a negative value
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 3:01pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/9 "2020-02-11T15:01:24Z")
It looks down, it’s just imperceptible in comparison to the much larger values.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 3:03pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/10 "2020-02-11T15:03:01Z")
But, see the value of “S345” is 11k and has not gone up
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 3:04pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/11 "2020-02-11T15:04:56Z")
here in the PIE
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 3:08pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/12 "2020-02-11T15:08:51Z")
So you are using a period (.) for your thousands separator. I use a comma (,) and a decimal point (.) to me is any value that is a fraction of 1. I and assume Glide is interpreting your value as 11 instead of 11k.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 3:27pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/13 "2020-02-11T15:27:14Z")
I tried both ways and it didn’t work …
 
---
### Author:  [@George\_B](https://community.glideapps.com/u/George_B)
#### Post date: [February 11, 2020, 3:35pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/14 "2020-02-11T15:35:27Z")
IMHO it would be a lot easier to read if you changed the look (even temporarily) to a white instead of a black background. I agree with @Jeff_Hager that it doesn’t make sense to expect a pie chart to work with negative numbers. Why don’t you create one in native Sheets and show us what a pie chart looks like there with negative numbers. I have no idea myself but I would be curious to see.
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [February 11, 2020, 4:52pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/15 "2020-02-11T16:52:11Z")
Glide considers 633 to be much larger than 11.85 for example. Can you remove all formatting from your numbers in your sheet?
One thing that’s confusing is that the labels on the y-axis are slightly off the lines that mark those values. 0 for example is above the x-axis.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 4:57pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/16 "2020-02-11T16:57:14Z")
else, the calculation is “50%” the chart displays “0.5”
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 4:58pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/17 "2020-02-11T16:58:43Z")
else, the calculation is “50%” the chart displays “0.5”
 
---
### Author:  [@david](https://community.glideapps.com/u/david)
#### Post date: [February 11, 2020, 5:54pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/18 "2020-02-11T17:54:37Z")
When you use percentages in Sheets/Excel, the actual values are decimals like 0.5 for 50%.
---
### Author:  [@Alysson\_Correa](https://community.glideapps.com/u/Alysson_Correa)
#### Post date: [February 11, 2020, 5:58pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/19 "2020-02-11T17:58:14Z")
[Improvement] It would be interesting when selecting on an item and it takes me to the summary of the information (drawdrill)
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [February 11, 2020, 5:58pm UTC](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500/20 "2020-02-11T17:58:52Z")
You could multiply the percentages by 100 to get a number out of 100.
[Next page](https://community.glideapps.com/t/help-me-understand-charting-percentages-and-negative-values/4500.md?page=2)