View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default 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.