Access2007 - OLE MS Graph Chart, data not shown

[john john mackey]

I want to display a schedule in a Gantt chart, MS Project-like, horizontal stacked bar chart. I embedded an unbound OLE object on my form, selected MS Graph Chart, and defined Row Source = qry_MySched, Row Source Type = Table/Query. What I am seeing is my rows/columns are transposed and I a missing a row of data that should display. Here is my data:

tbl_Schedule (ID, StartDay, Duration)
1, 1, 3
2, 6, 5
3, 7, 4

qry_MySched (SQL format)

SELECT "Event " & [ID] AS Label, [StartDay]-1 AS [Begin], tbl_Schedule.Duration
FROM tbl_Schedule;

Resulting in the query:

Event 1, 0, 3
Event 2, 5, 5
Event 3, 6, 4

My stacked bar chart then has (Y-axis): 3, 0 (legend): Event 2, Event 3 (horizontal bar for "3") 0-5 (5units), Event2; 5-9 (4units), Event 3 (horizontal bar for "0") 0-5 (5units), Event2; 5-11 (6units), Event 3 Working with MS Graph Chart difficult in Access 2007. (Access 2007, WinXP, SP3) Thanks for any help, JJ