View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
pcor pcor is offline
external usenet poster
 
Posts: 148
Default Excel 2007 chart

I have data in col B row 1 to 10:
I have a chart of this worksheet showing col B row 1 to 1000
Here is the trouble:The chart shows the data in row 1 to 10 but also shows
ZERO's for the remainder of the chart. 9IN DUE TIME THERE WILL BE DATA ALL
THE WAY TO ROW 1000).I would like very much to have the chart show a blank
for any row that contains NO DATA.
Thanks