| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
skip cells with zero values in chart (cells not empty)
I don't want to display zeros in my line chart. The cells are not empty -
they contain a formula. I have used a simple if statement to hide a zero value - however the chart is still showing the datapoint as zero. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula returns empty; chart plots zero; I want to skip | Charts and Charting in Excel | |||
| Defauls Values In Empty Cells | New Users to Excel | |||
| How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
| How to select cells with values only (not empty ones)? | Excel Discussion (Misc queries) | |||
| Copying values but skipping empty cells | Excel Worksheet Functions | |||
Threaded Mode
