eliminate zero value cells from a chart in Excel

[Rbenaroya]

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?

 

[Bernard Liengme]

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