Chart suppression of zero's
 

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.

Chart suppression of zero's
 

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

"ncalpaperboy" wrote in message
...
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.

Chart suppression of zero's
 

Another option would be to make your chart dynamic:

http://www.cellmatrix.net/index.php/...de_zero_values

--
John Mansfield
http://cellmatrix.net





"ncalpaperboy" wrote:

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.