Forum Discussion

hellofredhotmailcom's avatar
hellofredhotmailcom
Copper Contributor
Jan 23, 2024

Displaying percentage using a doughnut chart

I'm using a formula of 

=(G70 / G69) * 100

to display percentage used between two cells. However, when I try to put this into a chart - i.e. a doughnut the data is completely wrong - or right for lower values but  goes south around 50%. Any ideas how to do this? Can percentage difference between two numbers actually be shown graphically? 

 

The formula output above remains correct all the while. It's just the chart that shows errors. 

Resources