App Development

[#1]

I have a table with weekly summary information.  When I use a line or bar chart, it displays empty/null values for dates.

Any recommendations on just showing weekly # graphically.

BTW, the dates are in YYYY/MM/DD format.

[robert_mika]

Could you post sample of your data?

[#3]

The following is sample of "Weekly" data.  Each entry has ##s for a week ending date.

Sample data:

WeekDateEnding	Location	Wk_TotalVMCount
11/9/14	NYC	999
11/16/14	NYC	2000
11/23/14	NYC	5000
11/30/14	NYC	1000
12/7/14	NYC	4000
12/14/14	NYC	4500
12/21/14	NYC	6000
12/28/14	NYC	999
1/4/15	NYC	2000
1/11/15	NYC	5000
1/18/15	NYC	1000
11/9/14	NYC	4000
11/16/14	NYC	4500
11/23/14	NYC	6000
11/30/14	NYC	999
12/7/14	NYC	2000
12/14/14	NYC	5000
12/21/14	NYC	1000
12/28/14	NYC	4000
1/4/15	NYC	4500
1/11/15	NYC	6000

[robert_mika]

tRY THIS:

load

  if(MID(WeekDateEnding,2,1)='/' OR MID(WeekDateEnding,3,1)='/',Date#(WeekDateEnding,'MM/DD/YY'),DATE(WeekDateEnding,'MM/DD/YY')) as WeekDateEnding,

      Location,

    Wk_TotalVMCount

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);