View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
suebee suebee is offline
external usenet poster
 
Posts: 2
Default How do I stop chart from plotting null values as zeros in excel 20

Blank (null) values plot as zeros in my charts. In excel 2003 I used
tools-options-active chart-plot empty cells as but I can't figure out how to
do this in excel 2007.