Thread
:
Displaying null values in charts
View Single Post
#
2
Tushar Mehta
Posts: n/a
Displaying null values in charts
Use NA() instead of "".
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article , =?Utf-
8?B?SWFpbiBBU0xE?= <Iain
says...
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.
Reply With Quote