Thread: How do I get charts to ignore results of a formula if it equals 0
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
  
Posts: 2,489
Default How do I get charts to ignore results of a formula if it equals0
Hi,

Use NA() instead of zero.
Depending on your chart type the point will not be plotted.

Cheers
Andy

ChrisRox wrote:

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
Reply With QuoteReply With Quote