| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip the Zeros in a chart
How can I have the chart skip Zero values?
I am using the formula below to leave the cell blank for values that are zero, but it still shows up in the chart messing up the line. Is there a chart setting for this or do I need to change the formula? =IF(N454=0,"",N454*4+150000) -- Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| skip & hit chart for lotto | Excel Programming | |||
| how do you skip empty cells or zeros when calculating the average | Excel Programming | |||
| do not show zeros in pivot chart (pie chart) | Charts and Charting in Excel | |||
| Formula returns empty; chart plots zero; I want to skip | Charts and Charting in Excel | |||
| Skip some columns when creating a chart | Charts and Charting in Excel | |||
Threaded Mode
