Chart to only reflect points where data present?

**mhb22079** · 12-03-2007, 07:35 PM

Hello:

I have a line chart that has multiple data sources that spans a period of 36 weeks with the option to add additional data source as needed. It currently treats blanks as a zero value so if something starts in week 3 and ends in week 10 is spikes up from 0 in week 3 then back down to 0 in week 10.

Is it possible for the start point of the line chart to be when data is entered and the points only be added when data is entered (thus if data entered in weeks 1-10 except weeks 5/6 that there will be 8 points).

Thanks!