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

  • Thread starter Thread starter Russell.Ivory
  • Start date Start date
R

Russell.Ivory

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
 
Back
Top