Empty Source Data

[Abdul]

Hello,

I have the following in sheet1

------- Sales --------------
Date Loc1 Loc2 Loc3 Loc 4
1/1/06 0 0 100 200
2/1/06 0 0 150 250
3/1/06 0 0 100 100
........

25/1/06 0 100 200 300

At the beginning some of the locations have no sales. but at a later
stage they get sales figures, since these are new locations.

I making chart on these location based on dates.
How I can determine for a certain date whether there is data available
for a location or not?

Like if I slect 1-3 location 1 and 2 do not have data and location 3
and 4 do have data.

Thanks

 

[Peter T]

I'm not sure how you want to cater for your no-data cells. Depending on
that, and how you are plotting your chart, experiment with -

delete 0's
replace 0's with =#N/A, eg =IF(A1<>0,A1,#N/A)
Tools > Options > Charts > Plot empty cells as

Regards,
Peter T