Help With Radar Chart
Hi all,
sorry i'm new to radar charts within excel.
I am trying to create a radar chart that shows the statisitcs of footballers.
The problem is some of the statistics are in % and some are in numbers. I want to be able to format each column/axis of the radar chart to have different maximum's and minimum values and to use different formats such as % and then numbers.
Look below at my data I have
passing % 89.00% key passes 3.20 througballs 1.80 scoring contribution 0.35 succesful dribbles 3.00 dispossessed 1.30 fouls 2.80 dribbles past 0.80 tackles 1.10 interceptions 1.70 long balls 3.00
I want passing % to be maximum 100% minimum 0%
I want key passes to be maximum 8 minimum 0
I want dispossessed maximum to be 2.5 minimum 0
How is it possible to do this kind of chart. If I upload my current spreadsheet with my radar on could somebody look at it and explain how I do what is needed
|