Hi! I am back with one more interesting post. Here I will show you a chart example. Yes my friend charts are very very important things to know in Excel. Rather than wasting time let’s discuss about a Radar Chart example on the Cristiano Ronaldo’s skill set data which I found in FIFA video game website.
What is a Radar Chart?
This is a spider web look alike chart. It may be used to represent the values relatively from a center point.
So here we can see in the above picture that Cristiano Ronaldo is having these following skill score out of 100. Now you have to represent these data with a Radar Chart.
Now you have to go to Insert>Charts>Insert Stock, Surface or Radar Chart and then you insert a Radar Chart
After inserting a blank chart in the worksheet you have to right click on the chart and click on select data. Click that button beside Chart data range which is shown in above picture.
Now select these two columns with values and name and press OK. See the above picture.
Now your chart is almost ready. You can format it by clicking on Chart Tools or clicking on the button beside the chart which looks like brush.