Do not show value in Excel graph

[AtomicWedgie]

Hello,

I have a graph which has a formula (IF) as input. However if the formula returns no value it is still represented as a 0 value in the chart. If the formula returns no result the item should also not be shown in the graph.

Can anybody tell me how to fix this.

Thatnks in advance,

Atomic Wedgie

 

[GlennUK]

Replace the 0 in your formula with NA().

For example:

=IF(mymonth<reportend,B45,NA())

( don't know what your formula is, so this is a total guess, but hopefully you see the idea )


Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[AtomicWedgie]

Thanks GlennUK,

works great

Atomic Wedgie