eliminate zero value cells from a chart in Excel

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

Guest

I am trying to chart a series of data that has some zero value cells. I
don't want the chart to pick up zero value but rather treat them as a blank
cell. Any idea how to do that?
 
1) Replace the zeros by =NA() which the chart engine ignores.
OR
2) Replace them with blanks; then with chart selected use Tools |Options ,
open the Chart tab and specify how missing data is to be treated-
interpolated is your best bet.
best wishes
 
Back
Top