I'm trying to create a chart with multiple data points. I've attached an excel sheet to show the data and it also has an image. I've figured out how to get the final result, within a manual process, hence the image, but I'm hoping for a less manual solution, maybe using a pivot chart.

Excel Question.xlsx

Thanks for your help.

Jeri B.