Re: plotting "empty" cells that contain a formula that has returned a blank

From: Tushar Mehta (tmUnderscore200310_at_tushar-mehta.SeeOhEm)
Date: 06/29/04 

Date: Tue, 29 Jun 2004 17:43:29 GMT

Instead of return a blank (" " or "") result, return a NA().

If you need a null string ("") for subsequent calculations or for
aesthetic purposes, create a 2nd dummy range that has NA() instead of
"".

Plot the range with the NA()s 

-- 
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <2313501c45de7$46672590$a001280a@phx.gbl>, 
anonymous@discussions.microsoft.com says...
> Cells that appear empty, but contain a formula that has 
> returned a blank, when plotted on a line chart, plot as 
> ZEROS. This is in spite of setting tools, options, charts 
> to "zero values not plotted". Does anyone know a way round 
> this, please.
> 
> thanks
> Bob Farey
>

Relevant Pages

  • Re: plotting "empty" cells that contain a formula that has returned a blank
    ... I am trending a series over a priod of time say day 1 to ... create a 2nd dummy range that has NA ... >Plot the range with the NAs ... >> returned a blank, when plotted on a line chart, plot as ...
    (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: Plotting Nulls
    ... The empty cells should display NAso change formula to if,z10) ... Select chart, use Tools|Options; open Chart tab and look at "plot empty ... > I am trying to x-y plot a data set. ... > at times I have zeros where no data is needed in a standardized format. ...
    (microsoft.public.excel.charting)
  • Re: Dont plot zero values
    ... If there are true zeros in the data, perhaps the easiest way to exclude them from ... This puts ugly #N/A errors into the sheet, but the chart doesn't plot the points. ... George Wilson wrote: ...
    (microsoft.public.excel.charting)
  • plotting "empty" cells that contain a formula that has returned a blank
    ... returned a blank, when plotted on a line chart, plot as ... ZEROS. ... This is in spite of setting tools, options, charts ...
    (microsoft.public.excel.charting)
Loading