Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting,microsoft.public.excel.misc
|
|||
|
|||
How to make Excel Chart not to display empty cells?
I have a range of IF formulas. Sometime IF returns number, sometimes "". The problem is that chart displays "" as value 0. Is there a way to force chart not to display those empty values? IF(condition; number_value; "") Marko |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display Units is not accessible in my Excel Chart | Charts and Charting in Excel | |||
Chart to display only bars for values that are > 3 & blank cells | Excel Worksheet Functions | |||
How do I get my Excel time-line column chart to display in color? | Charts and Charting in Excel | |||
How do I put a watermark under cells in excel and make it print? | Excel Worksheet Functions | |||
Excel: Can I display a chart when the mouse is over a cell? | Charts and Charting in Excel |