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. |
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 |