I have a list of test results, one row for each participant. (Each result is
in a seperate column)

I need to make a graph of all of their results when I click on their names.

Obvously I cannot create a graph for each one, as there could be hundreds of
participants, I need it to create a graph using relevent cell references for
each person on the fly.

I have seen this done in the past, but am unsure on how to accomplish this
myself.

Thankyou for any help you can give me

Dan

Hi,

Maybe you used one of these sites previous to get your information.

http://peltiertech.com/Excel/Charts/Dynamics.html
http://www.tushar-mehta.com/excel/ne...rts/index.html
http://www.stfx.ca/people/bliengme/E...ps/Dynamic.htm

Cheers
Andy

DanielWalters6 wrote:
I have a list of test results, one row for each participant. (Each result is
in a seperate column)

I need to make a graph of all of their results when I click on their names.

Obvously I cannot create a graph for each one, as there could be hundreds of
participants, I need it to create a graph using relevent cell references for
each person on the fly.

I have seen this done in the past, but am unsure on how to accomplish this
myself.

Thankyou for any help you can give me

Dan

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info