Chart shows summary of all data... need it to be grouped by Line

[KirkComer]

I have a chart that I need grouped. It shows only the summary chart for each grouped line.

Here is the chart SQL:
SELECT qry_focus1.[Main Section], Sum(qry_focus1.Hours) AS [Delay Hours-Summary], Sum(qry_focus1.Occurrences) AS [Delay Count-Summary]
FROM qry_focus1
WHERE (((qry_focus1.Line)=[Line]))
GROUP BY qry_focus1.[Main Section]
ORDER BY Sum(qry_focus1.Hours) DESC , Sum(qry_focus1.Occurrences) DESC;

Here is the design view showing the chart is in the Line Header:

One additional not is I read on some other threads here where I need to link master fields and link child fields as "Line". But when I do that my graph goes blank:

Attached is pictures of how the chart looks. My db links to SQL servers for the data but I attached it as well.