Chart using Multiple Data Sets and Dropdowns...

I'm completely lost on putting together a couple of charts/graphs, both of which I want to incorporate 3 drop-down options, which would be displayed onto one single graph

I wasn't sure if this would fall under the authority of a Pivot chart, but I could not get the multiple elements that I wanted to play nicely when I attempted. It might be the way I am organizing the data on the back end is not correct or optimal (See Attachment -I have 2 tabs with the data organized in different ways, for your reference).


For Chart #1, I want to have three options, with the option to include one or more data sets (over a specific time range)...

1). SELECT ONE OR MORE TRAFFIC METRICS --> Unique Visits; Page Views; Sent to Booking
2). SELECT ONE OR MORE PROPERTIES --> Hotel 1; Hotel 2; Hotel 3; Hotel 4; Hotel 5; Hotel 6
3). SELECT ONE OR MORE MONTHS --> June 2009; July 2009; August 2009; ... ... ; February 2012; March 2012


For Chart #2, I want a similar chart layout, but with Revenue and $ metrics (also over a specific time range)...

1). SELECT ONE OR MORE REVENUE METRICS --> Internet Revenue; Phone Revenue
2). SELECT ONE OR MORE PROPERTIES --> Hotel 1; Hotel 2; Hotel 3; Hotel 4; Hotel 5; Hotel 6
3). SELECT ONE OR MORE MONTHS --> June 2009; July 2009; August 2009; ... ... ; February 2012; March 2012


Again, I am not able to make a usable chart/graph that has all 3 elements and their subsets, and I'm to the point were just typing about it is hurting my head


Any help would be very much appreciated! If you go into the attached excel, I am trying to position the graphs in the blue and red shaded areas (you can remove fill color, btw). If such a graph is not possible, please let me know if there are any alternatives.

Hi,
May be with pivot table and pivot chart
I'm not sure this is what you expect
Hope this helps
Best regards