Hi,
i am just trying some things out and looking at the dynamic charts. At the moment the user has to select cell H3 and type in a number to select the player which updates the graph.
What i'd rather have is a drop down list which has all the players names in it and when the use selects this it then updates the graph. I'm guessing i'd have to have a formula in another cell that checks the name in the list and then goes back to the source data and then calls the row number which can then be used to update the graph. Any ideas on how to do this would be greatly appreciated - pref not vba methods!
I have attached the worksheet as well.
Thanks
Bookmarks