Lesson#94: You can add many chart data in same area

Hi! Continuing with chart topic. In previous post I showed you to use a radar chart and for what type of data you can apply. Now I will show that you can add many chart data in same area.

Previously we were having only one player skill set data with me. Now I have made a table with skill set data of six players for you. Here you have to put all player’s skill chart at same area. It’s very simple.

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 all the table like I have shown in the above picture. And it’s almost done.

See, the chart has arranged the data in a organized order and all the player skill set data are at same area. That’s how to add many chart data in same area.

Ohh! Press the OK button. 😛

Puspendu is the founder author of Excelabcd. He is a creative person, blogger and Excel-maniac guy.

Tagged with:

Leave a Reply

Your email address will not be published. Required fields are marked *