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 do I disable "Plot visible cells only" when it is greyed out? 1
how can an empty cell equate to non-plot point rather than zero? 2
How do i not plot values as zero? 3
Cannot find "Plot empty cells as" option in 2007 7
How do I stop chart from plotting null values as zeros in excel 20 3
How do I not plot zero values that result from a formula in Excel? 1
Don't plot zero values 2
Charting null values 4

Top