In Excel for Microsoft 365 on Windows, select the radar chart’s value axis, open Format Axis, and enter the values you want under Axis Options > Bounds for Minimum and Maximum. You can also set the major unit to control the spacing of the concentric gridlines; the category labels around the chart are not the scale axis.
Change the radar chart scale step by step
The scale is controlled by the numerical value axis, which runs outward from the chart’s center. Depending on the radar chart’s layout, its numbers may appear along one spoke, while the gridlines form circles or polygons around the center. Use these steps to set a fixed range:
- Click the radar chart to show its chart tabs.
- Click one of the numerical axis labels, or click a gridline associated with the value axis. If selecting it is difficult, use the chart’s Format tab and the Current Selection list to choose the value axis.
- Right-click the selected axis and choose Format Axis. This opens the formatting pane.
- In Axis Options, find Bounds. Enter a number for Minimum and Maximum, then press Enter after each entry.
- Under Units, enter a Major value if you want to change the interval between labeled rings or gridlines.
For example, if the chart shows scores from 1 to 10, you could set the minimum to 0, maximum to 10, and major unit to 2. The rings then mark 0, 2, 4, 6, 8, and 10. A fixed range is especially useful when comparing two radar charts: matching bounds make the shapes easier to compare fairly.
What the axis scale changes
A radar chart places each category on a spoke and plots the category’s value at a distance from the center. The value axis determines how far a given number sits from the center. Changing the minimum or maximum therefore changes the apparent size and shape of every series in the chart, even though the numbers in the worksheet remain unchanged.
The category axis is different. It supplies the labels for the spokes, such as Quality, Speed, and Support. You cannot change its numeric bounds because it is not a numeric scale. If you need to rename or reorder the spokes, edit or rearrange the category labels in the chart’s source data instead.
The radial value scale is shared across the series in a standard radar chart. Excel does not give each spoke or each plotted series its own independent scale. That shared scale is important: it lets readers compare values across categories, but it also means that a single series with an unusually large value can make the other series look compressed.
How to choose a useful minimum and maximum
Choose bounds that fit the meaning of the data, not just the range that makes the chart look dramatic. For ratings with a defined range of 0 to 10, a minimum of 0 and maximum of 10 preserves the full scale. For percentages, 0 to 100 is often an intuitive range. If the chart compares results from separate periods or groups, use the same bounds in each chart so that a similar-looking shape represents a similar level of performance.
Consider a team comparing five skills rated from 1 to 5. If the chart is intended to show scores against the complete rating scale, use a minimum of 1 and maximum of 5. That makes the chart use the actual rating range. If readers might interpret distance from the center as distance from zero, explain that the scale starts at 1. Setting the minimum to 0 instead makes the center represent zero, but it changes how much of the chart area the scores occupy. Neither choice is universally right; make the scale explicit and consistent.
A practical checklist for picking bounds:
- Respect the data’s valid range. A scale should not imply that values outside the allowed range are meaningful unless the chart has a clear reason to show them.
- Keep comparison charts consistent. Different automatic bounds can make identical values appear at different distances from the center.
- Leave room for future values. If new results may exceed today’s maximum, choose a suitable fixed maximum or expect to revisit the setting.
- Use sensible increments. A major unit of 1 may suit a small rating scale; a unit of 20 may suit percentages from 0 to 100.
Bounds, major units, and automatic scaling
Excel normally chooses axis bounds automatically based on the plotted data. Automatic scaling is convenient when you are exploring a dataset or when values change often. Its drawback is that the chart’s visual scale can change as the data changes. A value that looks close to the outer edge today may not look that way after a larger value is added.
Entering a minimum or maximum replaces the automatic bound with a fixed one. The bound does not alter the worksheet values; it only changes the chart’s display. If a value falls below a fixed minimum or above a fixed maximum, it may not be visible as expected, so check that all relevant data fit inside the range. In the Format Axis pane, use the adjacent Reset control for a bound, when shown, to return that bound to automatic scaling.
The major unit controls the interval between principal axis marks. It affects the readability of the scale, not the data. If you set a maximum of 12 and a major unit of 3, the intended intervals are 3 units. A smaller interval can make values easier to estimate but may clutter the chart; a larger interval keeps the display cleaner but gives less visual detail. Excel may display additional minor gridlines if they are enabled, so the visible grid can include more than the major intervals.
Radar chart type and visual interpretation
Excel offers radar chart variations, including a basic radar chart, a radar chart with markers, and a filled radar chart. The axis-scale controls apply to the value scale rather than changing what those chart types mean. Markers can help readers locate individual observations. A filled radar chart emphasizes the area enclosed by a series, but overlapping fills can obscure one another and make precise comparisons harder.
Changing the scale can have a particularly strong visual effect on a radar chart because the plotted values form a polygon. Raising the minimum draws values closer to the outer edge relative to the remaining scale; lowering the maximum can also make the shape occupy more of the plot. The polygon’s area may change substantially even though the values do not. Avoid choosing bounds merely to make one series look larger, especially in a report intended to compare performance.
For many precise comparisons, a dot plot or bar chart is easier to read because values share a straight baseline. Radar charts are most useful when the goal is to show a profile across a modest number of related categories, not to make fine distinctions between many close values.
Common problems and fixes
- Format Axis does not appear: Make sure you selected the numerical value axis, not a data series, category label, or chart background. Try selecting the value axis from the Format tab’s Current Selection list.
- The number labels are missing: The axis may be hidden or its labels may be set not to display. Check the chart elements and axis formatting. You can still select an axis through Current Selection when it is available.
- Values look clipped: Check that the fixed minimum and maximum include every value you intend to show. Restore a bound to automatic scaling or enter a wider range if necessary.
- Changing one bound makes the chart look distorted: That is a consequence of changing the distance represented by each unit. Reconsider the minimum and maximum, and compare charts only when their scales match.
- One large value dominates the chart: Verify the source data first. If the value is valid but the series are measured on incompatible scales, a radar chart may not be appropriate. Consider transforming the data to a common, clearly explained scale or using separate charts.
- The axis changes after data edits: One or both bounds may still be automatic. Set fixed bounds when comparisons across updates must remain visually consistent.
Excel for Mac and Excel for the web
In Excel for Mac, the basic approach is similar: select the chart’s value axis, open Format Axis from its context menu, then edit the bounds and units in the formatting pane. Depending on the Mac interface and selection, Control-click or a two-finger click can open the context menu. The exact pane layout may differ from Windows, but look for the axis options and bound fields.
Excel for the web may expose fewer chart-formatting controls than the desktop app, and available options can vary as Microsoft updates the service. If you cannot find editable minimum, maximum, or units for the radar chart in the browser, open the workbook in the desktop version of Excel and set the scale there. The change is saved with the workbook and can then be viewed in the browser.
When to use another chart or prepare the data
If different measures have very different units—for example, response time in seconds and customer rating out of 10—putting them directly on one radar chart can make the comparison meaningless. The chart has one shared radial scale, so a measure with larger raw numbers can dominate. Convert measures to a common basis only when that conversion is defensible and explained, or use separate charts with clearly labeled scales.
Likewise, if you are comparing many categories or need readers to identify small differences, a line chart or clustered bar chart may communicate the results more clearly. If you keep the radar chart, use a modest number of categories, keep the category order consistent across comparisons, and label the scale so readers can interpret the rings without guessing.
Frequently Asked Questions
Can I set a fixed maximum on an Excel radar chart?
Yes. Select the value axis, open Format Axis, and enter the required value under Axis Options > Bounds > Maximum. Press Enter to apply it.
Can I change the minimum without changing the data?
Yes. The minimum is a chart display setting. It does not edit or recalculate the values in the worksheet, but it changes how those values are positioned visually.
Why do all the radar chart spokes seem to use the same scale?
Because the spokes are categories and the chart uses one shared numerical value axis for its series. The categories do not each have separate numerical bounds.
How do I make the radar chart gridlines show smaller intervals?
In Format Axis, reduce the Major unit under Units. For example, a maximum of 10 with a major unit of 1 gives more major intervals than a unit of 2.
Why does a radar chart look different after I add a data point?
If a bound is automatic, Excel may recalculate the scale to accommodate the changed data. Set fixed minimum and maximum values when you need the visual range to stay stable.
Related
- Excel Number Format With Leading Zeros: How It Works
- Excel Number Format for Thousands With Commas Explained
- Excel Number Format for Leading Zeros: How It Works
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- How to Make a Histogram in Excel With Custom BinsTo make a histogram in Excel, select your numeric data, choose Insert > Insert Statistic Chart > Histogram,…
- Excel Pie Chart From a Single Column: How It WorksIn Excel for Microsoft 365 on Windows, select a column of numeric values, then choose Insert > Insert…
- Excel Chart Bars: Conditional Formatting MethodsExcel does not apply worksheet conditional formatting directly to chart bars. To color bars according to a rule,…
- Excel Graph: How to Move the X-Axis to the BottomTo move an Excel chart’s x-axis to the bottom, select the vertical (y) axis, open Format Axis, and…
- Excel Bar Chart Tutorial: Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, place category names in one column…
- Google Sheets Chart Themes: How to Set and CustomizeIn Google Sheets, a chart’s appearance can come from the spreadsheet’s overall theme or from settings on the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.