topic Re: Displaying weekly data points in a line or bar chart in App Development

Displaying weekly data points in a line or bar chart

Wed, 11 Mar 2015 19:17:49 GMT

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 — Wed, 11 Mar 2015 20:21:57 GMT

Could you post sample of your data?

Wed, 11 Mar 2015 21:25:22 GMT

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

Sample data:

robert_mika — Thu, 12 Mar 2015 09:17:27 GMT

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);