| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Graphing 0 values from blank cells
My formula is:
=INDIRECT("'Enter data'!i$19") i19 in the "Enter data" sheet referenced in the formula is blank, but the formula returns a "0" in the cell. I do not want a "0". I just want it blank. And it is graphing a "0" value when I create a graph based on the worksheet with the formulas. Any suggestions on how I can prevent/change this from happening so that the "0" is not returned or graphed. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| TRANSPOSE results in zero values for blank cells | Excel Worksheet Functions | |||
| Graphing blank cells as gaps | Excel Discussion (Misc queries) | |||
| If certain cells not blank, and cells in range are, set values to | Excel Discussion (Misc queries) | |||
| blank cells plot as zero values | Charts and Charting in Excel | |||
| How to blank out cells with duplicate values? | Excel Discussion (Misc queries) | |||
Threaded Mode
