View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] SoccerTedTx@yahoo.com is offline
external usenet poster
 
Posts: 2
Default Chart values for blanks show as zero (Excel 2003)

I have a chart for quarterly activity (13 weeks per quarter).
The chart data is a static range which is updated weekly.
For weeks which have not occurred yet the fields are blank. However, the
chart shows these weeks as having zero and plots them on the chart.
How do I avoid this and only have blanks on the chart?

Thanks for your assistance,