Pie Chart Help

[UnluckyXIII]

Hi All,

I'm hoping someone can help me in how I would go about creating a Pie Chart that can show my data (example data below).

Ice Cream Flavours	Taste	Texture	Smell	Crystals	Availability
Vanilla	1	2	3	2	1
Chocolate	2	3	1	2	2
Strawberry	2	2	1	2	2
Mint	3	2	2	1	1

So the data above shows each flavour of ice cream with 5 metrics which they are measured against (1 = Good / 2 = Ok / 3 = Poor), I want to be able to create a pie chart that will look at this data and let me know how many of the flavours have a 3 rating for each metric (I'm happy to have 1 chart per metric).

I've played around in excel but can't seem to manipulate the data in a way that gives me the results I would like, does anyone know if what I'm trying to do is possible? And if not what alternatives do I have?

Kind regards,
XIII

 

[Anthony47]

In my opinion you'd bettere use a "Radar style" graph

Bye

 

[UnluckyXIII]

In my opinion you'd bettere use a "Radar style" graph

Bye

Hey, a Radar graph seems like a possible solution, is there a way to make it so results showing a zero or one are not displayed as the above is "dummy data" and the data pool I'm working with is fairly large so the radar becomes illegible

 

[Anthony47]

You need to create a copy of your data where datas lower than a set threshold are shown as #N/A, and then base the graph on this copy of data; as shown in the image, the graph at the right.

The formula used in I3 (and then copied through the table) is

=IF(B3>=$H$2,B3,NA())

H2 contains the threshold

Bye