Excel Graph with #div/o error

[waters130]

I am trying to create a bar graph that comes off of data out of a pivot table. The data will change depending on what warehouse or product class that is shown. The fill rate percentage is calculated and then shown on a bar graph.

The problem is that some days, nothing is shipped out of a warehouse, so I get a #div/0 error. This shows up as a zero on the bar graph. I would rather that it is blank. If I delete the formula it will show up as zero, but I need the formula left in for when a different warehouse is selected from the pivot. I tried the following formula without any luck.

=IF(B8="","",B9/B8)

Thanks,

waters130

 

[AnotherHiggins]

This will do the trick:

=IF(B8="",#N/A,B9/B8)

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[waters130]

Thank you so much!

waters130