View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Abe-air
 
Posts: n/a
Default How do you stop excel from charting empty cells/null values as zer

I'm trying to create several charts from my excel data. Several of the
chart's reference cell (established range) contains formuals. When the
cell's formula returns a null value, chart display's as zero. How do I setup
chart to display null as nothing versus zero?