View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
ivan ivan is offline
external usenet poster
 
Posts: 67
Default Charting only the dates shown

I am using Excel 2007 and have a chart of dates and accompanying data. Excel
is being very nice and adding in all the missing dates for me. I do not want
it to do this. How can I tell Excel to just plot the data that it sees
thankyouverymuch?

Basically I am plotting a burndown chart and am excluding weekends because
no work is done at that time. Excel adds in the weekend dates.