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!
 

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Forum statistics

Threads
1,214,641
Messages
6,120,694
Members
448,979
Latest member
DET4492

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top