+ Reply to Thread
Results 1 to 2 of 2

Select a Student and Produce a Radar Chart

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

    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
    Essex, UK
    MS-Off Ver

    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.

+ 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


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