Chart suppression of zero's

G

Guest

HI, for a chart series of historical data that is not yet populated, I want
to suppress the chart plotting of zero's. The option of plot empty cells as
'not plottted' does not work. Thank you.
 
D

David Biddulph

Are the cells empty, or are they the result of a formula returning an empty
string ""? If the latter, replace the "" by NA().
 

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

Chart not to pull Zero's 5
How not to plot zero's 6
How do I plot "" as empty rather than zero in a chart 1
How to change series plotting order without changing legend order? 6
Hiding 0 in pie charts 4
Blanks chart as zeros 10
Excel Chart 2
Prevent non-numerical data (e.g. text) from plotting on a chart 1

Top