Show line based on available labor hours

[act2]

I have a bar graph that shows the amount of machining hours by function per week. I want to be able to have a line based on the available labor for that week. Here is a sample of the data. I have not done a lot with graphs in access so any help will be appreciated. Thanks

Graph SQL:

TRANSFORM Sum([JobHr]) AS [SumOfJobHr] SELECT [WkNumber] FROM [qryReportGen] GROUP BY [WkNumber] PIVOT [JobType];

Line data

JobType Available
--------Hours Per week
Design--100
Layout---86
CNCp----267
CNCm----234
EDM-----276
Grind---240
Wire----168
Assy----145
Tuneup--100

 

[act2]

I have been able to get what I want in excell but no luck in Access.