Hello everyone...

I need help. I need my chart to include the grand totals in a secondary axis (line chart)... but I can't seem to figure out how. I have enclosed a photo and a worksheet. Any help you could provide me would be greatly appreciated. Maybe I am taking the wrong approach to compiling this information. The Pivot Table has broken the data out correctly, I just cant get the totals on the chart.

12345.jpg

GTAVG.xlsx