Chart suppression of zero's

N

ncalpaperboy

HI, for a chart series of historical data that is not yet populated, I want
to suppress the chart plotting of zero's. The option of plot empty cells as
'not plottted' does not work. Thank you.
 
D

David Biddulph

Are the cells empty, or are they the result of a formula returning an empty
string ""? If the latter, replace the "" by NA().
 
Top