How to Make a Polar Chart in Excel

Creating a polar chart in Excel can be a great way to visualize cyclical data, like percentages over time. In this Excel tutorial, you learn how to make and design a polar chart in Excel.

Layout and Design of Your Data

You’d need to lay out your data. The data should be similar to what is displayed in the picture shown above. It is also important to make sure that the data corresponds with what you would like to address.

polar chart table data set

You should mark the title, which in this case is the “timely delivery percentages” and make sure that the size of the columns is adjusted with the help of clicking on the (A, B, C, etc.) as the one showing right above the number 1 (marked in red), and right on the straight line, stretch the size of the column.

Then, you should go to the Merge & Center that is found on the Home tab of Microsoft Excel. Click on it, and click on the Merge & Center that shows once you click on the one marked number 2.

merge and center

After you’ve completed the previous step, you can now mark the title and select the merged column. You should click on it (it is marked as number 1 in the pic), and then click on the Cell Styles (marked as number 2 in the pic), and choose the color in the one labeled as number 3.

In this case, accent 5 was chosen for the title. You should now mark the title and time. You could do this by marking the columns that have to do with the parts you want to mark. In this case, we have chosen the months using the SHIFT key and the CTRL key while choosing the title area, and we will continue to select the columns that include the title with SHIFT.

See also  How to Overlay Graphs in Excel

Then do the same with the value data and choose a color for it. Make it look like it is in the picture shown below.

call styles

Polar Chart Creation

Click on the table (number 1), and then click on INSERT (number 2). Then you would click on the Recommended chart, which is marked as number 3. Furthermore, you should click on all the charts that are marked with the number 4.

Once you see number 4, you should choose the Radar (number 5), and finally choose the kind of chart you would like, which is number 6, and finally choose the one you would like to have, and click on Ok.

insert radar chart

Tips: You could just use the one marked in red and labeled as Alt in the picture above to create the polar chart.

Click on the title chart, and type in the title of the chart you have created.

polar chart ready

You now have your polar chart ready.

You can download a free polar chart template here.