In an Excel radar chart, the lines radiating from the center are category-axis lines, often called spokes; the rings or polygon-shaped lines are value-axis gridlines. To change the spokes in Excel for Microsoft 365 on Windows, select the chart, open the Format tab, choose the category axis in Current Selection, select Format Selection, and use the Format Axis pane’s Fill & Line settings to apply a line or choose No line.
What radial lines mean in a radar chart
A radar chart places categories around a circle and plots each data series against a shared value scale. Excel connects the plotted values for each series, creating a shape that can be compared with the shapes for other series. The background lines help readers judge where each value falls.
Two different sets of background lines are easy to confuse:
- Radial lines, or spokes: These extend from the chart center toward the category labels. Each spoke corresponds to a category axis position, such as Quality, Speed, and Cost.
- Value-axis gridlines: These form rings or polygon outlines around the center. They mark value levels, such as 20, 40, 60, 80, and 100.
Excel draws the plotted series as additional lines or filled areas. Those data lines are not gridlines, even though they may cross or follow the same general directions as the spokes. Identifying which kind of line you mean is the key to formatting the chart correctly.
Show or hide the category spokes
To change the radial category-axis lines in a standard radar chart, first select the chart. If the chart is crowded, click its outer border rather than a data line so that the chart-specific ribbon tabs appear. Then use the Format tab’s Current Selection controls to choose the category axis and open Format Selection. The Format Axis pane should appear on the right.
In the pane, open Fill & Line, expand Line, and choose Solid line to show or restyle the axis line, or No line to hide it. When you choose Solid line, you can set its color, transparency, and width. The exact axis label in Current Selection can vary with the chart and Excel build; look for the category axis rather than the value axis or a data series.
If you can select a spoke directly, clicking one category-axis line generally selects the axis rather than only that individual spoke. If direct selection is difficult, use Current Selection. You can also click the chart, open Chart Format, and use the selection list there. Avoid choosing a series name: changing its line settings would alter the plotted data rather than the chart’s background spokes.
To restore spokes after hiding them, select the category axis again and choose Solid line. If the Format Axis pane displays only axis options or labels, check that the category axis—not a data series, the chart area, or the value axis—is selected, then return to Fill & Line.
Change the rings and value scale separately
If the lines you want to adjust are the circular or polygon-shaped bands, format the value-axis gridlines instead of the category axis. Select one of those gridlines and open its formatting pane; the pane title should identify major or minor gridlines. Under Fill & Line, you can change the gridline color, width, and transparency. Selecting a gridline can be fiddly when data lines overlap it, so use the chart’s selection controls if clicking keeps selecting a series.
Gridlines are useful only when their spacing supports the comparison. To change the scale, select the value axis and open Format Axis. Under Axis Options, set appropriate bounds and units where Excel allows them. For example, a 0-to-100 score chart may be easier to read when the minimum is 0 and the maximum is 100, with major intervals of 20. If one series contains values far above the others, an automatic maximum can make the smaller differences hard to see.
Be cautious about changing the minimum. Radar charts usually communicate values relative to a common center, and a nonzero minimum can visually exaggerate differences. If the measures are percentages or scores with a meaningful zero, keeping zero at the center is generally easier to interpret. If the data cannot sensibly use a shared scale, the chart may not be a suitable comparison in the first place.
Add or remove chart gridlines
If the chart has no visible background lines, select it and use Chart Design > Add Chart Element > Gridlines. The available gridline choices depend on the chart type; choose the offered major or minor gridline option that applies to the value axis. Radar-chart gridlines normally appear as rings or polygon outlines, while the category-axis spokes are controlled as axis lines. The chart’s on-screen Chart Elements button, shown as a plus sign beside a selected chart in Windows, can also offer gridline controls.
Excel may already have gridlines enabled but make them difficult to see because their color is close to the chart area, their width is very thin, or a filled data series covers them. Try selecting a gridline and increasing its contrast or width before adding another chart element. If you add gridlines and see no obvious change, verify that the relevant value axis is visible and that the chart type is actually Radar, Radar with Markers, or Filled Radar.
Minor gridlines divide the intervals between major values. They can help with detailed reading, but too many lines make a radar chart look like a web of competing shapes. For a presentation chart, a few clear major rings are often more useful than many faint subdivisions.
Choose a readable style for the lines
The best line treatment depends on what the chart is meant to show. For a chart comparing a few profiles, subtle spokes can help connect each category label to its value, while moderately visible rings make the scale readable. For a small chart or one with many categories, thin, light spokes and only major rings reduce visual clutter.
- Use contrast deliberately: Keep background lines lighter than the data-series lines so the measurements remain the focus.
- Use width sparingly: Thicker spokes can overpower series outlines, particularly when several series overlap.
- Keep the scale consistent: When comparing multiple radar charts, use the same value bounds and major interval wherever possible.
- Check labels at the final size: A chart that looks clear on a large monitor may become crowded when inserted into a report or slide.
Radar charts are most readable with a modest number of categories and series. With many spokes, category labels can collide and the center can become visually dense. Removing every spoke may simplify the plot, but readers can then have trouble tracing values to categories. A balanced approach is to keep the category labels, retain enough scale gridlines to estimate values, and make the spokes secondary rather than dominant.
Build the chart with data arranged clearly
Excel expects categories and series to be arranged in a table. Put category names in the first column and each series in its own following column, with series names in the header row. For example, rows might list Design, Reliability, and Support, while columns contain Team A and Team B scores. Select the table and choose Insert > Waterfall, Funnel, Stock, Surface or Radar Chart > Radar, Radar with Markers, or Filled Radar.
Use ordinary Radar when the outline of each series matters. Radar with Markers adds a visible point at each category, which can help distinguish individual values. Filled Radar colors the areas inside series shapes, but overlapping fills may obscure both data and background lines. If a filled chart is hard to read, switch to an unfilled radar type or reduce the visual emphasis of the fills before adjusting the spokes.
If the categories and series appear in the wrong orientation, select the chart and use Chart Design > Switch Row/Column. Check the legend and category labels afterward: a chart with the wrong orientation can seem to have missing or misplaced radial lines when the actual issue is that Excel is treating rows as series instead of categories.
Common problems and what to check
The spokes are missing, but rings are visible: Select the category axis and inspect its line setting. It may be set to No line, or its color may blend into the chart background.
The rings are missing, but spokes remain: The category axis is present, but value-axis gridlines may be turned off or formatted invisibly. Add the relevant gridlines from Chart Design > Add Chart Element, then format them for contrast.
Clicking a line selects the wrong object: Data-series lines can overlap the background. Use the Current Selection list to choose the category axis, value axis, or gridlines directly. Confirm the selected object in the Format pane before making changes.
The chart looks distorted: Review the value scale, units, and data. A single unusually large value can expand the scale and compress other series toward the center. Also confirm that all categories use comparable units; combining unrelated measures on one radar chart can create a misleading shape.
Formatting changes do not stick: Make sure you are changing the chart element, not a selected data series, and that you have not selected a different chart in the worksheet. If the chart is copied into another workbook or application, some formatting may be adapted to the destination theme.
Radar charts compared with other chart types
A radar chart is useful when the same set of categories is measured for a small number of groups and the overall profile is meaningful. It is less effective when readers need precise comparisons. Values near the top and bottom of the circle are not always as easy to compare as values on a common horizontal scale, and the polygon shape can draw attention to area or symmetry that is not important to the data.
Use a clustered bar chart when exact category-by-category comparisons matter, especially with many categories or series. A line chart is often clearer when categories have a natural order, such as months or stages. In those charts, the meaning of horizontal and vertical gridlines differs from the radar chart’s spokes and rings, so do not assume a setting that controls one chart type maps visually to another.
Frequently Asked Questions
How do I add radial lines to an Excel radar chart?
Select the chart, choose the category axis through the Format tab’s Current Selection list, and open Format Selection. In the Format Axis pane, choose Fill & Line > Line > Solid line. If you mean the rings instead of the spokes, add or format the value-axis gridlines.
How do I remove the spokes but keep the circles?
Select the category axis and set its line to No line in the Format Axis pane. Leave the value-axis gridlines enabled. The spokes and rings are separate chart elements, so hiding the category-axis line does not require removing the gridlines.
Why does my radar chart show rings but no spokes?
The category-axis line may be hidden, have no line selected, or use a color that blends into the chart area. Select the category axis from Current Selection and inspect Fill & Line. If it is not selected, you may be formatting the value gridlines instead.
Are radar chart radial lines the same as gridlines?
Not in the usual Excel chart terminology. The center-to-edge spokes belong to the category axis. The circular or polygon-shaped value guides are gridlines associated with the value axis, although people may casually call both sets gridlines.
Can I change just one spoke?
Excel’s normal axis formatting applies to the category axis as a whole, so it is not a straightforward way to style one category spoke differently. If one category needs special emphasis, consider labeling or annotating it, or use a separate shape carefully; a shape will not automatically follow changes to the chart data.
Related
- Excel Number Format K: Show Values in Thousands
- Excel Number Format: Keep Leading Zeros in Your Cells
- Excel Number Format: Hide Zeros Without Deleting Them
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 Large Org Chart in PowerPointTo make a large org chart in PowerPoint, first organize the reporting structure, then use Insert > SmartArt…
- Add a Line to a Clustered Column Chart in ExcelTo add a line to a clustered column chart in Excel, select the chart, choose Chart Design >…
- Excel Pivot Table: Add a Field to Filters and RowsTo add a PivotTable field to both a filter and a row, open the PivotTable Fields pane and…
- 3D Pie Chart in Excel: How to Create and Format ItTo create a 3-D pie chart in Excel for Microsoft 365 on Windows, select a two-column list of…
- Excel Chart Title From Cell: Link, Format, and FixesTo link an Excel chart title to a cell, select the chart title, click the formula bar, type…
- Excel Pivot Table Filter: How to Invert SelectionExcel PivotTables do not have a dedicated Invert Selection command for filters. To show everything except a few…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.