Automatic Graphs

[DanielWalters6]

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

 

[Bob Greenblatt]

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

One way to do this is to set up a sample row to chart. Build the chart from
this row. Calculate these cells to chart via a vlookup into the range that
has the actual data. Use a drop down list to select the names and set the
argument for the vlookup.