I have made some charts with the data populating the underlying tables using
Vlookups. However as they are populated over time i dont want to show any
null values. I have tried the following formula =IF(D14=0,"",D14) to convert
the 0 values in to a null value but it still shows it on the chart. Do you
know how to get around this and if it is possible.