Radar Chart - Help!

[#1]

Hi

Trying to create a Radar Chart from the following data:

Candidate	Importance A	Performance A	Importance B	Performance B	Importance C	Performance C
John	5	4	2	1	2	7
Jane	10	9	7	8	6	5
Simon	5	6	2	3	7	8
Sarah	5	9	8	2	3	7

I want to have a Radar chart that shows as per the below, averaging ths Candidate scores across A, B, C etc

This is loaded as a staight file from Excel - I cannot get this to work in QV. Please advise!!

Thanks

Joe

[Gysbert_Wassenaar]

Easiest is to transform your data a bit first. See attached qvw.

[#3]

Thanks, but I really want to keep the data as it is - the actual data I'm using is more extensive than my example, so I want to keep it in its raw format.

I can get Importance and Performance on separate Radar charts - but I really want to show them on one.

Joe