Copilot for Microsoft 365 Tech Accelerator
Feb 28 2024 07:00 AM - Feb 29 2024 10:30 AM (PST)
Microsoft Tech Community

Displaying percentage using a doughnut chart

Copper Contributor

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. 

2 Replies

Thanks for your reply. I cannot send a sheet here. @abdelazizallam