Excel does not include a built-in radial column chart type. You can approximate one by plotting each category as a thick radial line in an XY scatter chart: calculate the line’s inner and outer coordinates, add each category as a separate series, and format the lines to look like columns.
What a radial column chart shows
A radial column chart arranges categories around a circle, with each bar extending outward from a central baseline. The angle identifies the category, while the bar’s length represents its value. It can make a compact, circular display of repeated measures such as monthly results, sensor readings by direction, or scores across several departments.
The format is sometimes called a radial bar chart or a polar column chart, although chart terminology is not always consistent. It is different from a radar chart: a radar chart connects values around a web-like grid, while radial columns use separate bars. The distinction matters because Excel’s built-in Radar chart will not automatically produce radial bars.
What Excel supports natively
Microsoft 365 Excel for Windows has standard chart types such as column, bar, doughnut, scatter, and radar charts, but no native polar-coordinate column chart. A standard column chart uses a straight category axis; it cannot simply be switched to a circular axis. A doughnut chart has circular segments, but those segments represent parts of a whole rather than bars with individually scaled radial lengths.
For a faithful radial-bar appearance, an XY scatter chart is a workable manual approximation. Excel positions points by numeric X and Y coordinates, so formulas can convert a category’s angle and bar length into two plotted points. A straight line between those points becomes the bar. This technique is more involved than inserting a normal chart and needs some manual formatting, but it keeps the plotted lengths tied to cell values.
Prepare the data and choose a scale
Put category names in A2:A7 and nonnegative values in B2:B7. For example, use January through June as the names and 20, 40, 60, 80, 100, and 50 as the values. Arrange categories in the order you want them to appear around the circle. The formulas below assume six categories in those exact ranges; expand the ranges if you have more.
Choose an inner radius and an outer radius for the chart. In this example, the baseline is radius 1 and the largest value reaches radius 5. Giving the baseline a radius greater than zero creates a hole in the middle, so the bars start at a visible ring rather than the center. The length of each bar is then proportional to its value relative to the largest value.
- Use one consistent value scale for all categories. Do not independently rescale each bar.
- Sort categories deliberately: alphabetical order, calendar order, or another meaningful sequence can change how the chart reads.
- Use a different chart type if values can be negative or if exact comparisons are more important than the circular layout.
Calculate angles and bar lengths
Add helper columns for angle and outer radius. With category names in A2:A7 and values in B2:B7, enter this in C2 to assign equally spaced angles, then fill it down through C7: =2*PI()*(ROW()-ROW($A$2))/COUNTA($A$2:$A$7). The first category has angle 0, and the last is placed just short of a full turn, so the first and last categories do not occupy the same position.
With the same A2:A7 and B2:B7 layout, enter this in D2 and fill down through D7 to calculate each outer radius: =1+4*B2/MAX($B$2:$B$7). The constants 1 and 4 correspond to the chosen inner radius and the extra distance from the inner radius to the maximum radius. For the sample value 60, the result is 3.4, because 1 + 4 × 60 ÷ 100 = 3.4. The value 100 reaches radius 5.
For each category, create a pair of X coordinates and a pair of Y coordinates: one point at the inner radius and one at that category’s outer radius. If C2 contains the angle and D2 contains the outer radius, the inner-point X coordinate is =SIN(C2) and its Y coordinate is =COS(C2). The outer-point X coordinate is =D2*SIN(C2) and its Y coordinate is =D2*COS(C2). These formulas use the first category as the top of the circle and progress clockwise. With six categories, the third category has an angle of 120 degrees; if its value is 60, its outer point is approximately X = 2.94 and Y = -1.70.
Build the scatter chart
Make a small helper block for each category, with two rows containing its inner and outer X/Y coordinates. Each block will be one chart series. In Excel for Microsoft 365 on Windows:
- Select a blank cell, then choose Insert > Insert Scatter (X, Y) or Bubble Chart > Scatter with Straight Lines.
- Right-click the chart and choose Select Data. Use Add to create a series for the first category. Set its X values to that category’s two X-coordinate cells and its Y values to the corresponding two Y-coordinate cells.
- Repeat for each category, making sure each series uses only its own two coordinate points. If Excel has added unwanted series automatically, remove them in the Select Data Source dialog.
- Format each series as a line with no markers. Increase the line width until the bars look substantial, and assign colors as needed.
Because each series contains only two points, the straight line connects the baseline point to the value point. A thicker line makes that radial segment resemble a column. Excel’s plotted line does not have the same controlled angular width as a true polar bar; the apparent width is a styling choice, not another measure encoded by the chart.
Set the chart’s appearance and labels
Set both scatter axes to fixed bounds of -5 and 5 for the example’s radius range, then hide the axes, gridlines, and legend if they do not help explain the chart. To set bounds, select an axis, open Format Axis, and enter the minimum and maximum under Axis Options. Make the chart’s plot area roughly square: a rectangular plot area can distort the circle into an oval. If you later change the inner or outer radius, update the axis bounds to match.
Category labels take extra work because a scatter chart does not automatically place category names around the circumference. One option is to add text boxes around the chart. Another is to add labels to the outer endpoints: select the endpoint, add a data label, then use Format Data Labels and Value From Cells if that option is available in your Excel build. Keep labels outside the bars where possible, and check them at the final chart size. Labels attached to data points may overlap or move when the chart is resized.
For reference rings, you can add separate XY series containing points around circles at chosen radii and format them as thin, pale lines. That requires more helper coordinates and is optional. A few light rings can help readers judge lengths, but too many lines and labels make a small radial chart difficult to read.
Common problems and limitations
- The bars point in the wrong direction: check that the X formulas use SIN and the Y formulas use COS for a top-start, clockwise layout. Swapping those functions or changing signs rotates or reverses the display.
- The circle looks oval: make the plot area square and use matching axis bounds. The chart area itself can be rectangular, but the actual plotting region should not be.
- All bars look nearly the same: confirm that every category uses the same maximum-value range in the radius formula. A changing maximum can alter all lengths when the data changes.
- A formula returns an error: the radius calculation divides by the maximum value. If all values are zero, MAX returns zero and the calculation cannot produce a meaningful relative scale. Handle that case separately or use a conventional chart.
- Bars overlap: reduce line width or the number of categories. Thick lines can collide, especially when many categories are packed around the circle.
This design is best for nonnegative values. Negative values need a clearly defined baseline and a scheme for extending bars inward or outward; the simple radius formula above does not express negative amounts. Also, comparing angles and lengths around a circle takes more effort than comparing aligned bars, so avoid using the format when precise ranking is the main goal.
When to choose another chart
A standard clustered bar or column chart is usually clearer for ranking values, comparing small differences, or showing a long list of categories. Readers can compare lengths against a shared straight baseline more accurately than they can compare radial bars. A line chart is generally better for a time series when the sequence and change over time matter.
Choose a radar chart when the purpose is to compare profiles across the same set of categories, and the connected shape is useful. Choose a doughnut chart when the values are parts of a meaningful whole. Neither is a drop-in replacement for radial columns: each answers a different visual question. If the radial layout is essential, the XY-scatter construction gives more control than trying to disguise a doughnut chart as a bar chart.
Frequently Asked Questions
Does Excel have a radial column chart?
No. Excel does not provide a built-in chart type with radial columns. You can approximate one with an XY scatter chart and helper coordinates, or use a different chart type that better fits the comparison.
Is a radial column chart the same as a radar chart?
No. A radar chart plots values along spokes and usually connects them into a shape. A radial column chart uses separate bars extending from a circular baseline. The scatter-chart method creates separate line-like bars, not a radar polygon.
Can I make the chart update when values change?
Yes, if the helper formulas refer to the data cells and the chart series refer to those helper cells. The calculated lengths then update with the values. Adding or removing categories still requires updating the ranges and series structure.
Can radial columns show negative values?
Not reliably with the simple method described here. It maps nonnegative values to outward radii. For positive and negative comparisons, use a bar chart with a visible zero baseline or design a separate, clearly explained radial scale.
Does the method work in Excel for Mac or Excel for the web?
The underlying XY scatter chart and worksheet formulas are standard Excel features, though dialogs and formatting controls can differ by platform. On Mac, use the chart insertion and formatting controls available in the ribbon or chart menus. Excel for the web has more limited chart editing controls, so building and fine-tuning many series is generally easier in the desktop app.
Related
- Open Notepad with Excel: Use Both or Import Text Files
- Open a New Excel Spreadsheet: Quick Steps and Options
- OpenOffice Excel Files: How to Open, Edit, and Save
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Excel Chart Linking Errors: Are All Links Really OK?No: an Excel workbook can report that its external links are fine while a chart still points to…
- Google Sheets Chart With Two Y-Axes: Setup and TipsYes. In Google Sheets, you can put one data series on a second, right-side y-axis: open the chart…
- Balloon Chart in Excel: A Step-by-Step TutorialTo make a balloon chart in Excel for Microsoft 365 on Windows, arrange your data in columns for…
- How to Make a Trendline Solid in Excel and Fix DashesTo make a trendline solid in Excel for Microsoft 365 on Windows, select the trendline, press Ctrl+1, open…
- Excel Mac Chart Creation: Make and Format ChartsTo create a chart in Excel for Mac, select your data, choose Insert > Recommended Charts, select a…
- Custom Column Chart in Excel: How to Build and FormatTo make a custom column chart in Excel for Microsoft 365 on Windows, select your category labels and…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.