+ Reply to Thread
Results 1 to 2 of 2

Automatic Graphs/ Dynamic Graphs

  1. #1
    DanielWalters6
    Guest

    Automatic Graphs/ Dynamic Graphs

    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

  2. #2
    Andy Pope
    Guest

    Re: Automatic Graphs/ Dynamic Graphs

    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1