Petal Chart in Excel

A petal chart, also known as star chart because of its appearance, plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring.

Preparing Data

For practice purpose use following data to create star chart with similar results. For this you can copy this data to your worksheet, or you can use your own data.

To start with copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot in a petal chart.


Select the data that you want to plot in the star chart including labels.

Inserting Petal Chart

On the Insert tab, in the Charts group, click Other Charts.


Under Radar, click Filled Radar


If you further want to change color theme of the chart click the chart area of the chart. this displays the Chart Tools, adding the Design, Layout, and Format tabs.

On the Design tab, in the Chart Styles group, click the chart style that you want to use.

chart styles

To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height and Shape Width boxes, and then press ENTER.


Petal Charts are nothing but tweaked radar charts that segregate the information yet somehow provide comparability, The purpose of a radar chart is to compare m options across n parameters so that audience can be convinced that option A is better than say option B.

Yes you are right it very difficult to understand these charts in one go, because human eye is not trained to go around circles 4 times stopping at number of different parameters only to realize that all the options are equally bad (good), but still in some scenarios petal chart are only solution to present particular kind of data.


You can download the Template here – Download
Previous articleHow To Link Objects In Excel
Next articleGoogle Classroom Tutorial