RADAR diagrams - Format the data in my table for Radar diagrams /Spider diagrams

[jleete]

Hi, 

Goal:

• I'm trying to create a dashboard that will illustrate 200 schemes and how they score against 5 objectives, in a radar diagram.
• I imagine I'll use a splitter to change scheme, only showing one at a time

Current Issue:

• When importing the data, i have it laid out like this:
  

  ID:	1	2	3	4	5	6
  Objective 1	(score)	(score)	(score)	(score)	(score)	(score)
  ob 2	(score)	(score)	(score)	(score)	(score)	(score)
  ob 3	(score)	(score)	(score)	(score)	(score)	(score)

  This results in the radar diagram looking like this:

Which means that I have to individually include each scheme in the Y axis, and exclude it, to remove it from the diagram.

Is there a way to layout the original data input excel file to include all schemes and use a splitter to then create radar diagrams that are relevant to only one scheme at a time?