Radar Chart Help

Quicken23

New Member
Joined
Oct 12, 2014
Messages
1
Hi All,

Long time lurker here, and having searched the forum I can't seem to find any solution that may be relevant so hope someone could advise.

As way of example I'm looking to create a radar chart to show how the % of people that like Chocolate, Crisps, Cake and Biscuits (Total must = 100%)

Is there a way to:
1) Ensure that each segment of the chart/diamond is a different colour
2) Ensure each of the 4 vertical sides of the chart/diamond represents the preference (Cake, Crisps etc), so that if 100% of people like crisps, the whole plottable area of 1 of the 4 quadrants is completely shaded, but if only 50% of people like crisps, only half of the quadrant is shaded - and repeat for other preferences

Hope that is explained clearly enough... interested to know if there is a way to do this!
 

Some videos you may like

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type

Watch MrExcel Video

Forum statistics

Threads
1,109,033
Messages
5,526,368
Members
409,697
Latest member
christopherlewis1620

This Week's Hot Topics

Top