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 a spreadsheet with data in col b starting at row 1 and continuing down
to row 10. I want to have a chart depict the values in row 1 to 100 as I will
be adding data as time goes by.
The trouble that I am having is that although there is NO DATA in row 12 to
100 the chart shows ZERO. I would like the chart to show NOTHING in that area
until data has been added
Thanks