I've got the red and green columns doing what I want, I just can't figure out how to overlay a line that would show the averages like the blue one in the attached shot.
On the Chart Properties Data tab, you woul want to add a second data series which matches up with the line data. Then, click the Appearance table (once you clicked add / edit for the series) and click the plot as line checkbox.