Graphs - Multiple Worksheets (2016)

My first thought is to get all of the data that the chart needs into a single worksheet -- which gets challenging and/or tedious when you have multiple worksheets like this.

In a lot of these cases, the best long term solution is to combine the weekly worksheets into a single worksheet/database. Then you can use filters and pivots (and other database tools) to extract and summarize the data you need for the chart. Then build the chart from the filtered list or pivot table. The "Get and Transform" utility in 2016 should make combining worksheets into a single database fairly straightforward, though I am not familiar with it. You might review this thread and the accompanying web links: https://www.excelforum.com/excel-new...ta-layout.html

Without more detail, that's my thought.