Chart suppression of zero's

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Are the cells empty, or are they the result of a formula returning an empty
string ""? If the latter, replace the "" by NA().
 
Back
Top