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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how can an empty cell equate to non-plot point rather than zero? 2
plots sent to to a chart tab do not show plot & I loss the plot 0
Surpressing plot of blank cells 4
How do I disable "Plot visible cells only" when it is greyed out? 1
Cannot find "Plot empty cells as" option in 2007 8
negative number scatter plot 1
How do I not plot zero values that result from a formula in Excel? 1
XY Charts - not plotting zero or #N/A Points 2

Top