eliminate zero value cells from a chart in Excel
 

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?

eliminate zero value cells from a chart in Excel
 

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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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