software

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 -------------------------------------------------------------------
|Filename: test.zip |
|Download: www.excelforum.com/attachment.php?postid=4802 |
-------------------------------------------------------------------

--
infojmac
------------------------------------------------------------------------
infojmac's Profile: www.excelforum.com/member.php...oamp;userid=10787
View this thread: www.excelforum.com/showthread...hreadid=544336Here is your enhanced WB: cjoint.com/?fwr2OOAI7k

I Added a Datagt;Validationgt;List to pick up player
and modified original $H$3 with a MATCH formula to get index in
players'list.

HTH
--
AP

quot;infojmacquot; gt; a écrit
dans le message de news:
...
gt;
gt; Hi,
gt;
gt; i am just trying some things out and looking at the dynamic charts. At
gt; the moment the user has to select cell H3 and type in a number to
gt; select the player which updates the graph.
gt;
gt; What i'd rather have is a drop down list which has all the players
gt; names in it and when the use selects this it then updates the graph.
gt; I'm guessing i'd have to have a formula in another cell that checks the
gt; name in the list and then goes back to the source data and then calls
gt; the row number which can then be used to update the graph. Any ideas on
gt; how to do this would be greatly appreciated - pref not vba methods!
gt;
gt; I have attached the worksheet as well.
gt;
gt; Thanks
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: test.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4802 |
gt; -------------------------------------------------------------------
gt;
gt; --
gt; infojmac
gt; ------------------------------------------------------------------------
gt; infojmac's Profile:
gt; www.excelforum.com/member.php...oamp;userid=10787
gt; View this thread: www.excelforum.com/showthread...hreadid=544336
gt;

Well It depends, for what you want the attached should suffice, It uses
data validation for the drop down list of player name and then just a
vlookup with an exact match for their scores

Regards

Dav -------------------------------------------------------------------
|Filename: test.zip |
|Download: www.excelforum.com/attachment.php?postid=4803 |
-------------------------------------------------------------------

--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=544336Jon Peltier has interactive charting examples:

www.peltiertech.com/Excel/Cha...ByControl.html

infojmac wrote:
gt; Hi,
gt;
gt; i am just trying some things out and looking at the dynamic charts. At
gt; the moment the user has to select cell H3 and type in a number to
gt; select the player which updates the graph.
gt;
gt; What i'd rather have is a drop down list which has all the players
gt; names in it and when the use selects this it then updates the graph.
gt; I'm guessing i'd have to have a formula in another cell that checks the
gt; name in the list and then goes back to the source data and then calls
gt; the row number which can then be used to update the graph. Any ideas on
gt; how to do this would be greatly appreciated - pref not vba methods!
gt;
gt; I have attached the worksheet as well.
gt;
gt; Thanks
gt;
gt;
gt; -------------------------------------------------------------------
gt; |Filename: test.zip |
gt; |Download: www.excelforum.com/attachment.php?postid=4802 |
gt; -------------------------------------------------------------------
gt;--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Thanks for the help - just recreated it myself on a few other bits of
data - very handy.

Thanks--
infojmac
------------------------------------------------------------------------
infojmac's Profile: www.excelforum.com/member.php...oamp;userid=10787
View this thread: www.excelforum.com/showthread...hreadid=544336