I am trying to create a chart for use in the hotel industry. I have 24
hotels that I would like to chart future room rates over the course of a
month. I want the ability to select the hotels I would like to compare on a
line graph. Possibly check the hotel name which triggers the data to display
on the line graph.

Any suggestions would be greatly appreciated! I have tried to search for
"selectable data", "dynamic charts", etc. and can't seem to find what I need.
I am not an Excel expert but I work with the program daily.

Best regards.