Chart suppression of zero's

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

How do I plot "" as empty rather than zero in a chart 1
How do I disable "Plot visible cells only" when it is greyed out? 1
suppress zero values in line charts? 4
How do I keep zero values from plotting in charts? 6
How do I stop chart from plotting null values as zeros in excel 20 3
Excel 2002 Zero Values in Charts 2
Blank instead of "" 5
blank cells 1

Back
Top