Re: 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" <Rbenaroya@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:11C73667-1741-4666-87BE-798ABF7F4AC0@xxxxxxxxxxxxxxxx
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?


.

Relevant Pages

  • Re: Zero Values in chart
    ... Assuming you mean you want empty cells not to be treated as zeros: ... use Tools|Options|Chart and specify how you want blanks ... replace blanks by =NA ... > Is there any way to avoid displaying zero values in a chart. ...
    (microsoft.public.excel.charting)
  • Re: Help with special print preview format
    ... as these values won't be displayed in your chart. ... But if you have to display zeros on your sheet maybe the following ... total avg. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: plotting "empty" cells that contain a formula that has returned a blank
    ... create a 2nd dummy range that has NAinstead of ... Plot the range with the NAs ... > returned a blank, when plotted on a line chart, plot as ... > ZEROS. ...
    (microsoft.public.excel.charting)
  • Re: Dont plot zero values
    ... > the chart is to use an autofilter on the data that hides the rows with zeros. ... > Jon Peltier, Microsoft Excel MVP ... >> plot non zero values. ...
    (microsoft.public.excel.charting)
  • RE: removal of zero in column chart
    ... Where does the X axis cross the Y axis? ... You can use auto filter to hide zeros for data in columns. ... > a chart, which is regularly updated as I change the weekly values. ... > have the chart only display the>0 values and display NO COLUMN if the ...
    (microsoft.public.excel.charting)