How to Create a Petal Chart in Excel for Data Visualization

A petal chart, also known as a star chart, is a type of radar chart that plots the values of each category along a separate axis that starts in the center of the chart and ends in the outer ring. Petal charts are a useful way to compare multiple values across multiple categories.

Preparing Data

For practice purposes, use the following data to create a 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.

Petal Chart table

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.

Petal Chart ribbon

Under Radar, click Filled Radar

petal chart

If you want to change the color theme of the chart, click on 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.

petal 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.

See also  How to Create an Interactive Map Dashboard in Excel