Line Chart Not Charting Correct Data
I'm having trouble getting a line chart to chart the appropriate data. I am tracking KPIs for my sales team and collecting in a source sheet. I then have a report for each sales person that pulls their data from that sheet. I have made each of them a dashboard so they can see their progress and I want to charge their data over time on the dashboard. We have the KPI data going back multiple years, but I'd like to just chart this year to date and last year to date laid over eachother.
What I ultimately want is one chart with 2 lines: a line for 2018 and a line for 2019. X axis should be Week # of the year and Y axis should be the metric (count of something or $ of something). I've included screenshots of everything I have.
How do I set this all up so it will chart what I want? Or, what's the closest I can get to that?