Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Displaying null values in charts
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Displaying null values in charts
Functions must return something, and Excel has no null value.
Since your issue appears to be future values, Tushar's suggestion of NA() should work just fine. If you needed connecting lines to break, you would have to work much harder. The options there are to either - delete the formula (possibly with a macro to re-load the formula as data changes) - use helper columns as described at http://www.andypope.info/charts/brokenlines.htm Jerry Iain ASLD wrote: 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Min values in a list of numbers | Excel Worksheet Functions | |||
Stacked Charts w/ Vertical Separation | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
displaying several charts, one at the time | Charts and Charting in Excel |