Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Empty Source Data
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
list from empty data cell source | Excel Worksheet Functions | |||
cell auto population - why 0 when source cell is empty? | Excel Discussion (Misc queries) | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions | |||
How create a nonblank source for a verification list with a mix of filled & empty cells? | Excel Programming | |||
How can i set the source-data-range of pivottable2 to the source . | Excel Discussion (Misc queries) |