Empty Source Data
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
"Abdul" wrote in message
oups.com...
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
|