Make a Pivot Wheel Chart in Excel: Steps and Options

Yes. In Excel for Microsoft 365, make a PivotTable, insert a PivotChart, and select a radial style such as Radar if it suits your data. “Pivot wheel chart” is not an official Excel chart name, so the right steps depend on whether you mean a radar chart, a doughnut chart, or a wheel-shaped display of hierarchical data.

What people mean by a pivot wheel chart

A PivotChart is a chart connected to a PivotTable: its categories, series, and values respond to the PivotTable’s field choices and filters. A “wheel chart,” by contrast, is an informal description rather than a specific Excel feature. People often use it to mean one of three visuals:

Radar, or spider, chart: categories sit around a circle, with values plotted along spokes. Connecting the points creates a web-like shape.
Doughnut chart: categories appear as slices in a ring. It shows parts of a whole, not values arranged on spokes.
Sunburst chart: rings show levels of a hierarchy, such as department, team, and product. It is useful for nested categories, not for comparing many independent measures.

For a wheel with spokes, Radar is usually the closest match. The chart type and the PivotChart connection are separate choices: the PivotTable summarizes the data, while the chart type determines how that summary is drawn.

Prepare the source data

Start with a rectangular table in which each column has one descriptive heading and each row represents one record. For example, a sales dataset might have columns for Month, Region, Product, and Sales. Avoid merged cells, blank header names, and subtotal rows inside the source range; those can make PivotTable creation or field interpretation harder.

Decide what the wheel should compare before building it. A radar chart works best when the categories are meaningful and the series use the same measure and scale. For example, compare monthly customer-satisfaction scores for three service teams, with months as the spokes and one line per team. Comparing sales dollars, customer counts, and percentages together on one radar chart would be confusing because the units and ranges differ.

For a source range that will grow, convert it to an Excel Table first: select a cell in the data and press Ctrl+T on Windows, then confirm whether the table has headers. A PivotTable based on a Table can include newly added rows after you refresh it. On Mac, use Command+T to create a table; the ribbon names and placement can differ slightly.

Create the PivotTable

Select a cell in the source data. On Windows, choose Insert > PivotTable.
Check the proposed table or range and choose where to put the PivotTable, such as a new worksheet. Select OK.
In the PivotTable Fields pane, drag fields into the layout. Put the categories you want to compare in Rows, a numeric measure such as Sales in Values, and optional grouping fields in Columns or Filters.
Check how Excel summarizes the value field. If it displays Count when you expected Sum, the source values may contain text or blanks; use Value Field Settings to choose an appropriate summary and inspect the source data.

For a radar example, put Month in Rows, Team in Columns, and Satisfaction Score in Values. The resulting summary has one row per month and one series per team. If your source records contain multiple survey responses per month and team, Excel might sum the scores by default. Use Average instead if the intended comparison is the average score, and make sure that choice matches the question you want the chart to answer.

Insert the PivotChart

Click inside the PivotTable, then choose PivotTable Analyze > PivotChart on the Windows ribbon. In the chart dialog, select the chart type and subtype, then confirm. In some Excel layouts, the PivotChart command is also available from the Insert tab. The chart remains linked to the PivotTable, so changing its filters or rearranging its fields changes the view.

Choose Radar for a spoke-based wheel. Excel offers radar variations, including a plain radar chart, a radar chart with markers, and a filled radar chart; names and the dialog layout can vary by build. A filled version can obscure overlapping series, so markers or unfilled lines are often easier to compare. If Radar is not offered for the PivotChart you are creating, create a regular chart from a clean copy of the summarized PivotTable results instead.

Excel for Mac also supports PivotTables and PivotCharts, but ribbon placement and dialog appearance may differ from Windows. Select the PivotTable and look for the PivotTable or Analyze tab’s chart command. If the relevant chart type is unavailable in your Mac version, use a standard chart based on the summarized results. Excel for the web has fewer chart-editing options than the desktop app, so use desktop Excel for detailed chart-type changes.

Choose the right circular chart

Pick the visual based on the structure of the information rather than on the wheel shape alone. A radar chart compares multiple series across a set of shared categories. It is most legible with a modest number of spokes and a few series. With many categories, the labels crowd together; with many series, the lines overlap.

A doughnut chart is better when each category is a share of one total, such as the proportion of orders by product group. It does not show a trend across spokes, and similar slice sizes can be difficult to distinguish precisely. A sunburst is designed for nested levels—for instance, a company’s divisions, then teams, then products. Excel’s Sunburst is a standard chart type, not necessarily a PivotChart option. If you cannot insert it from a PivotTable, summarize the data in a normal range and build a standard Sunburst chart from that range.

For an ordinary comparison of totals over time, a line or column PivotChart is often clearer than a wheel. Circular charts can make small differences harder to judge because readers compare angles, areas, or distances from the center. Choose the wheel only when its circular layout helps explain the data, not just because the data came from a PivotTable.

Format the chart so it can be read

Give the chart a title that states the measure and scope, such as “Average satisfaction by team and month.” Add a legend when there are multiple series, and use distinct, consistent colors. For Radar charts, keep the value axis scale consistent when comparing charts side by side. If each chart automatically uses a different maximum, shapes may look comparable even when their underlying values are not.

Use a sensible number format and avoid unnecessary decoration. For example, a score from 1 to 5 should not be presented as a percentage unless it has actually been converted to one. If category labels are long, shorten them in the source or use a different chart type; rotating or crowding many labels around a circle rarely improves readability. You can edit the title and chart elements with the chart selected using the Chart Design and Format tabs in desktop Excel.

PivotCharts may display field buttons on the chart. These let viewers filter or rearrange fields, which can be useful in an interactive report but distracting in a finished presentation. Look under the PivotChart Analyze tab for the field-button display controls; the exact options can vary by Excel build. Hiding buttons changes the chart’s appearance, not the underlying PivotTable.

Refresh and troubleshoot the result

A PivotChart reflects its PivotTable, and the PivotTable reflects the source data as of its last refresh. If you add or change records and the chart does not update, click the PivotTable and choose PivotTable Analyze > Refresh, or use Data > Refresh All to refresh workbook connections and PivotTables. If new records fall outside a fixed source range, update the PivotTable’s data source or base it on an Excel Table that expands as rows are added.

The chart shows counts instead of totals: inspect the source values for text, blanks, or inconsistent entries, then adjust Value Field Settings.
A category or series is missing: check the PivotTable field layout and any active report, row, or column filters.
The wheel looks crowded: reduce the number of categories or series, filter to a useful subset, or switch to a line or bar chart.
The chart type is unavailable: Excel restricts some chart types for PivotCharts. Make a regular chart from the PivotTable’s summarized output when the type you need is not supported.
New rows are not included: refresh the PivotTable and check whether its source range includes those rows.

One common misconception is that changing a PivotChart’s type makes it a different kind of summary. It does not: the PivotTable still determines how records are grouped and aggregated. Conversely, a regular chart based on PivotTable output may look like the same wheel, but it may not respond to PivotTable field changes in the same integrated way. If you use that workaround, check whether the chart range continues to cover the summarized results after filters or refreshes.

When a regular chart or another tool is better

Use a standard chart when you need a chart type the PivotChart menu does not allow, or when you want a carefully arranged chart based on a fixed summary. Copying PivotTable results as values makes a stable snapshot, but it will not automatically track later changes. Linking a standard chart to a summary range can retain some updating, though the range and layout need to remain suitable.

For a hierarchy, prepare a clean table with one column per level and a numeric value column, then try Excel’s standard Sunburst chart if that format is available in your desktop version. For detailed comparisons among many categories, a sorted bar chart is usually easier to read. The practical test is whether a reader can accurately compare the values and understand the grouping without needing to decode the shape.

Frequently Asked Questions

Is there a chart type in Excel called Pivot Wheel?
No. PivotChart is Excel’s name for a chart linked to a PivotTable; “wheel chart” is an informal description. Radar is the usual choice for a wheel with spokes.

Can I make a radar chart from a PivotTable?
In desktop Excel, select the PivotTable and use PivotTable Analyze > PivotChart, then choose Radar if it is available. If Excel does not offer it, chart a suitable summarized range with a standard Radar chart.

Why does my PivotChart show Count instead of Sum?
Excel may treat the value field as nonnumeric if the source contains text or inconsistent entries. Check the source column, then choose the intended calculation in Value Field Settings.

Will a PivotChart update when I add data?
Refresh the PivotTable after changing the source. If the new rows are outside a fixed source range, change the range or use an Excel Table as the PivotTable source.

Should I use Radar or doughnut for a wheel chart?
Use Radar to compare several series across shared categories. Use doughnut to show category shares of one whole. Neither is ideal for every comparison; a bar or line chart may communicate exact differences more clearly.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.