View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
John John is offline
external usenet poster
 
Posts: 2,069
Default Surpressing plot of blank cells

I'm creating a line chart plot using Excel 2007. The data range for plot
lines contains some blank cells. These blank cells get plotted as zero
points.

How do I change this behavior to plot only points that have values and to
leave the blank cells unplotted?

I appreciate your help, -John