| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to stop excel from plotting a "blank" cell with formula as zer
Hi,
I have an xy chart that plots Date vs. SVI. The SVI column has a conditional formula that if the condition is met it will display a value, otherwise it will display a blank cell. Even though the cells appear blank they really contain a formula and excel plots them in the chart as zero values. Is there a way to stop excel from thinking that the value of the cell is zero? I don't want it to plot this values. Please help. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cell set to wrap text and blank line -- fix? | Excel Discussion (Misc queries) | |||
| COPY A CONCATENATE CELL TO BLANK CELL PUTTING IN THE NEXT BLANK C. | Excel Discussion (Misc queries) | |||
| Show Blank is cell value=0 but count as a zero in sum. How to format this cell ? | Excel Worksheet Functions | |||
| No Smart Tag help: just a blank "MS Excel Help" window - Excel 2003 | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Threaded Mode
