Chart

  • Thread starter Thread starter SS
  • Start date Start date
S

SS

Hi

I want to plot a chart but it not to show the values if the value of the
formula is zero even though they are ranged.

Is there anyway this can be done?

Cheers
Shona
 
Hi Shona,

Try using the NA() formula instead of zero or ""

Cheers
Andy
 
You must log in or register to reply here.

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 2
set cell to empty 1
Bizarre chart behaviour when changing axis cross at points 2
Excel 2007 Chart Options 4
How to stop excel from plotting a "blank" cell with formula as zer 5
Plotting a Graph 2
Help with displaying formulas in charts 4
Labels on Charts 2

Back
Top