| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Chart displaying "blank" cells?
In Excel 2007, I would like my chart to not display chart data for empty cells.
On the "Hidden and Empty Cell Settings" I have "Show empty cells as: Gaps". I can't seem to get this to work, but my cells aren't empty perse. They return a formula value: =IF(<condition=0,"",<formula) The cells that are being displayed (as 0) on the chart appear blank in the spreadsheet. Any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not displaying "FALSE" in cells | Excel Worksheet Functions | |||
| multiplying by blank cells input by "IF" functions | Excel Discussion (Misc queries) | |||
| Avoiding "0" importing blank cells from another Excel file | Excel Discussion (Misc queries) | |||
| How to fill in "BLANK" Cells Automactically...Large Spread Sheet | Excel Discussion (Misc queries) | |||
| Changing "returned" values from "0" to "blank" | Excel Worksheet Functions | |||
![Brandon[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
