Interactive Excel 2007 Charts

Good Afternoon,

I have a line chart in Excel 2007 that is set up to compare two entities -- the user is able to choose the base entity from the 1st drop down and the entity to compare from the 2nd drop down. There are 3 measurements for each entity, therefore there are 6 measurements total showing in the chart (making it really busy). I would like to create yet another drop-down that would allow the user to choose one or all of the 3 measurements. I am attaching a sample of the spreadsheet so you may hopefully see what I am trying to accomplish.

Thank you in advance for your help,
Rachel

Hi Rachel, welcome to the forum.

If you wouldn't mind, please post your solution to the question as it may help someone else searching for an answer in the future.

Thanks!