Interactive Chart (Two Values via Drop Down)

I am trying to chart two different values/metrics on the same chart, and customize the chart labels and chart title.

First, I was hoping to get some help getting both sets of data to show up on the chart. I cant figure out where the issue is within the name manager.
Secondly, I was hoping to change the data labels on the chart from the Market Name in the drop down to the Metric Name (i.e. Page views and signups)
Third, I wanted to get the Market Name (from the dropdown) to dynamically show up as the chart title.

Hello
Not completely sure I've got what you're looking for, but take a look a the attached reply file. Both Chart series are selected from the bottom data validation list and there are 2 dynamic named ranges ('Traffic' & 'Signups') which feed the series values to the Chart.

I'm not sure which version of Excel you're using, as you mentioned the Name Mangager and the file format is 2007 and later but your user information says 2003. So I hope the file runs Ok.

DBY

That worked!! Thanks so much for your help!

---------- Post added at 05:26 PM ---------- Previous post was at 05:18 PM ----------

I see that you cleaned up the names in the name manager. SO great. appreciate it. Yes i'm using excel 2010 but need to update my profile here. Thanks again!

@ bp2010

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.

Also, as an infrequent user of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.