top of page
Search

Radial chart is also known as Polar line chart is useful for displaying cyclical data of several series in a circular form. In a radial visualization , each bar appears in a circle with loger bars that represent larger values.

Let us see how to create amazing radial chart .

Here I am taking a simple dataset contains teamwise result of a competition

Create a union with same table sheet1. We can see a new column ‘Table Name’ at the end

Create a calculated field Path for starting point 0 and endpoint 270.

Create bins for Path with size 1

Create an Index calculated field. I used INDEX()-1 because first row of index starts from 1 but Path value starts from 0 to 270

RADIANS function converts number from degrees to radians value. SIN funciton to return Sin value and COS function returns Cos value of a number.

Put X on rows and Y on Columns. Put Path(bins) to Columns and make sure that all Missing values are checked.

Make Marks to line and move Path(bin) to path

Click on X – Compute Using – Path(bin)

Click on Y – Compute Using – Path(bin)

Now to show case teams put Team number to color. We want each team in different circles. So we need to create calculated fields for that

Total_Cal_GrandTotal

Rank_calc – Will help to create different circles for different teams

Now we need some changes in X and Y values.

Multiply X and Y values with Rank_calc

Again Click on X and Y and make it to Compute Using Path(bin)

Go to Edit table Calculations – Nested Calculations – Rank_calc

Select Team Number instead of Path for both X and Y

We have different circles for different teams. Next we need to create a calculate field Total Grand total

We have to create Percentage calculation

Create a calculated field that helps us to change the size of radials based on the percentage.

Make changes in our X and Y calculatios

No radial in our chart . Inorder to make radial we need to repeat the process

Go X an Y Make it Compute Using Path(bin)

Edit table calculations. Again change Rank_calc – Path to Team Number

And select Size_cal in our nested calculation - Select both Path(bin) and Team Number and move Team Number to top

For Total_gTotal follow the above steps also

Follow the same steps for Y calculations as well

We can see that our radial chart has taken the shape as we needed

Have you noticed exercise ring in apple watch?. Its a radial chart in real life scenario