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.
