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
Bookmarks