chart zero

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, first Post - so here goes....

I am ploting a simple chart in Excel - when the value of a cell, say F5, is
zero (calculated as =F4/F3) or F4 and F3 are zero and F5 returns #DIV/0! - I
don't want to plot that cell at all.

At the moment it is plotted as zero in both cases.

I'm using Excel 2000.

Many Thanks
Andy
 
Have just found the other threads dealing with this issue - #N/A and a white
font will do it for me.

Thanks anyway guys
Andy
 

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

Surpressing plot of blank cells 3
Blank instead of "" 5
Zero value and bar graph 1
zero values 1
How do I stop chart from plotting null values as zeros in excel 20 3
HOW THE HELL Can I get excell to stop ploting blank cells 4
Hiding zeros in dynamic charts 3
How do I plot "" as empty rather than zero in a chart 1

Back
Top