Chart with Negative Percentage (Can't Divide by 0)

[clayt101]

Is it possible to do what I am trying to do? I am trying to show the amount of money spent, compared to what we have been allocated. The issue is where money has been spent, but we have $0 allocated...ie you can't divide by 0.
In mind, on the attached picture, the percentage for "Other Charges" should be undefined or an error, since it should be graphing (0-64.85)/0.

Is there anyway to show this differently?
Thanks

 

[Jeffrey Mahoney]

Hi,

Yeah, dividing by zero is a mathematical sin. When I know I have possibilities of dividing be zero I add a little fudge factor. I create a named range called "rsn". The formula for rsn is =1e+300.

Then in my cell I change it to: (0-64.85)/(0+rsn)

Since rsn is a Really Small Number, it won't affect your values by any significant amount. Matter of fact if the allocated amount is zero, your value will look like zero.