+ Reply to Thread
Results 1 to 2 of 2

Select a Student and Produce a Radar Chart

  1. #1
    Registered User
    Join Date
    05-13-2010
    Location
    Sheffield, UK
    MS-Off Ver
    Excel 2010
    Posts
    1

    Select a Student and Produce a Radar Chart

    I have a list of 1000 students with 9 columns of data.

    because I know how to use excel I can select one student and produce a lovely radar graph of that data for that student.

    But can anyone suggest the easist way to setup the excel 2007 workbook, so any member of staff could open the file,
    select a student and the graph for that student would appear?

    With the sheet open I can select the chart and move the grean and blue cell highlights to change the chart data,
    but how could I do this for an Excel Novice.

    Thank you for any suggestions.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,400

    Re: Select a Student and Produce a Radar Chart

    Simplest way is to create the data for the chart using formula references to the selected student. The chart itself will always be based on the same range.

    You can use INDEX and MATCH formula to locate and display the required student.
    Cheers
    Andy
    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)

Tags for this Thread

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