How do I plot "" as empty rather than zero in a chart
 

I have an if statement that either populates cells with a numeric value or
blank, i.e. "". I then want to chart the result. For example, I might have
the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values ""
are interpreted as zero. If I truly have empty cells my plot is fine, only
plotting the 56,,85,75, . But since there is 'something' in the cell, i.e.
"", it wants to plot something. Is there a way to either populate the empty
cells with a code of some kind that would not plot, or somehow tell the chart
wizard to not to plot "" ?

I'm using Office 03 at work and 07 at home. I have the same problem with
both.

Thanks

How do I plot "" as empty rather than zero in a chart
 

Use NA() instead of ""
--
David Biddulph

"Russell.Ivory" wrote in message
...
I have an if statement that either populates cells with a numeric value or
blank, i.e. "". I then want to chart the result. For example, I might
have
the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values
""
are interpreted as zero. If I truly have empty cells my plot is fine,
only
plotting the 56,,85,75, . But since there is 'something' in the cell,
i.e.
"", it wants to plot something. Is there a way to either populate the
empty
cells with a code of some kind that would not plot, or somehow tell the
chart
wizard to not to plot "" ?

I'm using Office 03 at work and 07 at home. I have the same problem with
both.

Thanks

How do I plot "" as empty rather than zero in a chart
 

"David Biddulph" wrote:

Use NA() instead of ""
--
David Biddulph

"Russell.Ivory" wrote in message
...
I have an if statement that either populates cells with a numeric value or
blank, i.e. "". I then want to chart the result. For example, I might
have
the values 56, "",85,75,"" in cells A1:A5. When I plot this, the values
""
are interpreted as zero. If I truly have empty cells my plot is fine,
only
plotting the 56,,85,75, . But since there is 'something' in the cell,
i.e.
"", it wants to plot something. Is there a way to either populate the
empty
cells with a code of some kind that would not plot, or somehow tell the
chart
wizard to not to plot "" ?

I'm using Office 03 at work and 07 at home. I have the same problem with
both.

Thanks




That works perfectly, thanks!