More dynamic chart
Ok, what did I do this time? When I copy the formula down, I get the top value for 2009, that of Mr. or Ms. Smith. I even copied the formula as you have entered it on this page and pasted it into excel to make sure I wasn't making some typo I could spot because I made it. No go. I hate being stuck on the dime.
Interesting thing too. I downloaded the example to see what I had done wrong, and couldn't figure it out any better.
What I did find was that in your spreadsheet, when I hid the numbers so the user was looking at the horse race and not at the numbers, the chart did not show any results. What's up with that?