For a report, I have multiple worksheets, each one a different year. Each worksheet is a table that compares diseases and their percentage resistance to certain drugs for that year. The row labels are diseases and the column rows are the drugs.

I need to create line charts that track a certain disease's resistance to a drug over the years. How can I do that?