In Excel for Microsoft 365 on Windows, select the radar chart’s numeric value axis, right-click it, and choose Format Axis. Under Axis Options, enter the values you want for Minimum and Maximum in Bounds; this changes the shared scale used by the chart’s spokes.
Change the radar chart scale in Excel
The scale is controlled by the value axis, not by the category labels around the chart. On a radar chart, the value axis is usually represented by numeric labels near one spoke and by the concentric gridlines. If the labels are hidden, select a gridline that belongs to the value axis and open its formatting pane.
- Click the radar chart to activate its chart controls.
- Click a numeric value-axis label or a value-axis gridline. If you select a category label instead, the pane will show category-axis settings rather than numeric bounds.
- Right-click the selected axis or gridline and choose Format Axis.
- In the pane, open Axis Options and find Bounds.
- Enter the desired Minimum and Maximum, pressing Enter after each value if needed.
For example, a chart of scores from 0 to 10 can use a minimum of 0 and a maximum of 10. If the data ranges from 0 to 100, use those bounds instead. Excel may initially calculate the bounds automatically; typing a value makes that bound fixed, so the chart will not rescale it automatically as the source data changes. The precise pane layout can vary slightly with Excel updates.
On Excel for Mac, select the value axis and Control-click it, then choose Format Axis; the available bounds are in the axis-formatting pane. Excel for the web may offer fewer chart-formatting controls than the desktop app. If you cannot find the bounds fields in the browser, open the workbook in desktop Excel to set them.
What the radar chart scale controls
A radar chart puts categories around a circle and plots each category’s value along a spoke. The value axis determines how far a given number sits from the center. The concentric rings are reference levels on that same axis, while the category axis determines the labels and their positions around the circle.
Changing the minimum and maximum changes the mapping from numbers to distance. A value of 6 will be nearer the outside on a 0-to-10 scale than on a 0-to-100 scale. The underlying cell value does not change, and the chart does not convert or normalize the source data. It only changes how the existing values are displayed.
Radar charts use one common value scale for all categories and all series in the chart. You cannot give one spoke a 0-to-10 scale and another a 0-to-100 scale while keeping them in the same radar plot. This shared scale is important: it makes distances comparable, but it can make a category with a much larger numeric range dominate the visual.
How to choose minimum and maximum bounds
Choose bounds that reflect the meaning and units of the data, rather than selecting limits only because they make the shape look more dramatic. A full meaningful range is often the clearest choice, especially when readers need to compare charts or interpret values without reading every data label.
- Use zero as the minimum when zero represents none, a starting point, or the natural baseline for the measure. This gives the distance from the center a consistent interpretation.
- Use a nonzero minimum only with a clear reason. If all measurements are between 70 and 90, a 70 minimum can make small differences visible, but the center no longer represents zero. State the scale clearly because the visual gaps can look larger than they would on a zero-based scale.
- Set the maximum to a meaningful limit such as a score’s actual ceiling, the full percentage range, or a defined performance target. Avoid choosing a maximum below valid data values.
- Allow some headroom when values sit exactly at the maximum and the outer edge makes the shape hard to read. A slightly higher upper bound can separate the data from the chart border, as long as it does not mislead.
- Keep units consistent. Scores on a 1-to-5 scale, percentages, and raw counts should not be treated as if their numbers mean the same thing.
For percentage data, check how the source cells are stored. Values displayed as 20% and 80% are often stored as 0.2 and 0.8, so bounds of 0 and 1 may be appropriate. If the cells contain the numbers 20 and 80 and are merely labeled as points rather than formatted percentages, bounds of 0 and 100 may fit. The chart’s number formatting and source data format can affect what readers see, so verify the axis labels after changing bounds.
Example: scores on a 0-to-10 scale
Suppose a team rates four service areas—speed, accuracy, support, and reliability—with scores from 0 to 10. One series has values 8, 7, 9, and 6; a second has 6, 8, 7, and 8. Setting the radar chart’s minimum to 0 and maximum to 10 makes the chart use the complete rating range. Each score is then read against the same 0-to-10 scale, and the shape does not change its meaning if a different team’s results are added later.
If the chart instead uses automatic bounds based on the current observations, Excel may choose a narrower range to fit those values. That can make the two series appear farther apart than they would on the full rating scale. A narrower range can be useful for examining small differences, but readers should be told what the bounds are. For a chart used in a report, showing value-axis labels or adding a note such as Scale: 0–10 helps prevent misreading.
Do not infer a precise score from the polygon’s area or angle alone. Radar charts are best for a quick profile across a small set of related measures; data labels or a table are better when exact values matter.
Keep scales consistent when comparing charts
A fixed scale is especially useful when comparing two radar charts placed side by side, such as this month versus last month or one department versus another. If one chart uses automatic bounds and the other uses different automatic bounds, equally sized shapes may represent quite different numbers. Set the same minimum and maximum on each chart before comparing their visual profiles.
The same principle applies to a chart that has multiple series. Excel uses one value axis for all of them, which makes the series comparable within that chart. If one series has values in the tens and another has values in the thousands, the smaller series may appear compressed near the center. Do not try to solve that by assigning separate radial scales; consider converting the measures to a common, meaningful scoring system or using separate charts with clearly stated scales.
For a presentation, consistency includes more than bounds. Use the same category order, units, and interpretation across the charts. A common scale will not make unlike measurements comparable: a satisfaction rating and a dollar amount still need an explained transformation or a different visual.
Common scale problems and fixes
- The bounds do not appear: You may have selected the category axis or chart area. Click a numeric label or a concentric value gridline, then open Format Axis again. The pane should show numeric options such as bounds and units.
- The chart looks almost flat: Check whether one category has values much larger than the rest, or whether the maximum is far above the data. Confirm the source values and units before narrowing the scale; an accidental value such as 500 instead of 50 can distort the whole plot.
- Some points seem to disappear at the edge: Check whether any values exceed the fixed maximum or fall below the fixed minimum. Increase the range to include valid values rather than assuming the chart has changed the data.
- The shape changes unexpectedly after editing data: A bound set to a fixed number will remain fixed as values change. Review both bounds after updating the data, or return them to automatic sizing if you want Excel to recalculate them.
- Grid rings are too crowded or too sparse: In Format Axis, adjust the Major unit where that option is available. Bounds control the endpoints of the scale; the major unit controls the interval between labeled or displayed levels. For example, a 0-to-10 range with a major unit of 2 gives a different number of reference intervals than a unit of 1.
- The center does not represent zero: Inspect the minimum bound. A positive minimum moves the scale’s starting point away from zero, so values should be interpreted from the stated axis limits rather than from an assumed zero baseline.
If a bound was set by mistake, return to the same Bounds controls and restore automatic sizing using the Auto or reset control shown in your Excel build. If the pane does not show an obvious reset button, remove the entered fixed value and confirm the change. Check the chart afterward to make sure Excel has resumed choosing the range.
Radar charts versus other ways to show the data
Changing the axis scale cannot fix every problem with a radar chart. Radar charts work best when there are a modest number of categories with the same units and a clear shared range. With many categories, labels and lines can become crowded. With unrelated units, the outline can imply a meaningful balance that the data does not support.
A bar chart is often easier when readers need to compare exact values across categories, because lengths can be compared along a common straight axis. A line chart may be more suitable when categories form a meaningful sequence, such as months. If the goal is to compare profiles, radar charts can still be useful, but pair them with labels or a data table and use an explicitly chosen scale.
Frequently Asked Questions
Can I set a different scale for each spoke in an Excel radar chart?
No. A radar chart has one shared value axis for its categories and series. To display measures with different units or ranges, convert them to a justified common scale or use separate charts with clearly labeled bounds.
Why is the radar chart scale changing when I edit the data?
The chart may be using automatic bounds, which Excel recalculates to fit the data. Enter fixed minimum and maximum values in Format Axis if you need a stable scale, and review them when new data might fall outside that range.
Can the radar chart start above zero?
Yes. Set a positive minimum in the value-axis Bounds controls. This can make small differences easier to see, but it changes the visual baseline: the center represents the chosen minimum, not zero. Make the limits visible or explain them to readers.
How do I change the number of rings on a radar chart?
Change the value axis’s Major unit in Format Axis, if the option is available for that chart. A smaller interval generally creates more reference levels and a larger interval fewer; the minimum and maximum still determine the scale’s endpoints.
Does changing the axis scale change the values in my worksheet?
No. It changes only the chart’s display range. The source cells and their values remain the same, so formulas, tables, and other charts using those cells are not altered by changing the radar axis.
Related
- Excel Paste Keyboard Shortcuts: Copy, Paste Special & More
- Excel Password Protect to Keep a Workbook from Opening?
- Excel Packing List Template: What to Include and How to Use
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Bar Chart in Excel: How to Create and Format OneTo make a bar chart in Excel for Microsoft 365 on Windows, arrange category names in one column…
- Excel Pivot Table Date Grouping: Months, Years & FixesTo group dates in an Excel PivotTable, put the date field in Rows or Columns, right-click any date…
- Excel Stacked Column Chart With Two Data Sets ExplainedYes. In Excel for Microsoft 365 on Windows, place the two data sets in adjacent columns beside the…
- Excel Pivot Table Errors: Causes and FixesMost Excel PivotTable errors come from a blank or invalid source-data header, a changed data source, values that…
- Best Excel Gantt Chart Templates for Every ProjectFor most projects, the Vertex42 Gantt Chart Template is the best place to start: it gives you a…
- Excel Charts With Dynamic Ranges: Setup and OptionsTo make an Excel chart grow when you add data, convert the source range into an Excel Table,…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.