Excel Radar Chart Fill: Add, Color, and Adjust the Area

Charts & pivot tables · Updated November 19, 2026

To fill the area of an Excel radar chart, select the chart and choose Chart Design > Change Chart Type > Radar > Filled Radar. Then select a series and use Format Data Series > Fill & Line to adjust its fill color and transparency.

What a filled radar chart shows

A radar chart plots categories around a circle and places each series’ value along an axis extending out from the center. Excel connects the plotted values to form a shape. A filled radar chart colors the area enclosed by each series’ shape, making the chart look more like a set of overlapping polygons than a collection of lines.

This can make broad patterns easier to notice. For example, a team comparing three products across battery life, price, durability, support, and ease of use can use the filled shapes to see where each product has relative strengths. The shape is a visual summary, though: it does not make the values more precise, and a larger-looking area is not necessarily a reliable measure of overall performance.

Fill refers to the area inside a data series, not the chart’s background. Excel’s Filled Radar chart type adds that area. Changing the chart area or plot area color instead changes the background behind the data.

How to add fill in Excel

In Excel for Microsoft 365 on Windows, you can create a filled radar chart directly or convert an existing radar chart:

  1. Select the chart. To make a new one, first select the data, including the category labels and series names.
  2. Open Chart Design > Change Chart Type.
  3. In the chart type list, select Radar, then choose Filled Radar.
  4. Select OK to apply the change.

If you are starting without a chart, select the data and use Insert > Recommended Charts. Open the All Charts tab, choose Radar, and select Filled Radar if it is offered for your selection. The Change Chart Type route is useful when Excel initially chooses a different chart type or when you want to compare the line and filled versions of the same data.

On recent Excel for Mac versions, the chart type and series-formatting controls are also available from the chart design and formatting tools, though the pane layout can differ. The instructions here use the Windows Microsoft 365 ribbon. In Excel for the web, chart formatting options can be more limited; if a control is missing, open the workbook in the desktop app.

Set series color, transparency, and outline

To format a filled series, click its colored region. If the region is hard to select because shapes overlap, click the series in the chart legend first, or select it from the chart’s current selection using the arrow keys after selecting a chart element. Right-click the selected series and choose Format Data Series. In the formatting pane, open Fill & Line and expand Fill.

Choose Solid fill, select a color, and adjust Transparency so that other series remain visible. There is no single ideal transparency value: it depends on the number of series, their colors, and how much overlap the chart contains. Start with a noticeable but see-through fill and check the chart at the size at which people will read it. If the colors still merge together, use fewer series or switch to an unfilled radar chart rather than making every fill almost invisible.

The Line controls in the same pane let you adjust a series’ outline. A clear outline can help distinguish the boundary of a translucent area. Use contrasting colors for different series, but avoid relying on color alone: line styles, markers, and direct labels can provide another way to tell series apart. Formatting applies to the selected series; repeat the process for other series as needed.

Prepare the data before plotting

Radar charts work best when the data has a simple rectangular layout: one column for category names and one column for each series. For example, a product comparison might have the five attributes in the first column and the ratings for Product A, Product B, and Product C in the next three columns. Include a header for each series so Excel can create a useful legend.

After selecting the data, check that Excel has interpreted rows and columns correctly. If the legend lists categories as series, select the chart and use Chart Design > Switch Row/Column. If the category names or series names are wrong, use Chart Design > Select Data to review the chart’s data range and labels.

Keep categories consistent across all series. A missing value can change the shape or leave a gap, depending on how the chart is configured and how the data is represented. In Chart Design > Select Data, use Hidden and Empty Cells to review how empty cells are displayed when that option is available. Do not replace missing measurements with zero unless zero is genuinely what the measurement means; on a radar chart, zero places a point at the center and can drastically change the polygon.

Choose a scale that makes comparisons fair

Radar charts are most interpretable when every category uses a comparable scale. If one attribute is rated from 1 to 5 and another is measured in dollars or minutes, their plotted distances are not directly comparable just because they sit in the same chart. Consider converting the measures to a common, meaningful scale before charting, and explain what the scale represents in the title or a note.

Excel usually sets the value-axis bounds automatically. To inspect them, right-click a value axis and choose Format Axis; in Axis Options, review the minimum and maximum bounds. A manually fixed maximum can make charts easier to compare across reports, but choose it carefully. If the maximum is too high, all shapes may look compressed toward the center; if it is too low, the chart can exaggerate small differences or hide values outside the chosen range.

Also check whether the scale has a meaningful zero. Filled shapes emphasize the area from the center outward, so a scale that starts at a nonzero value may give a different visual impression from one that starts at zero. If zero is not a valid value for a measure, explain the scale clearly and avoid treating polygon area as a score. The chart communicates patterns; the underlying numbers remain the basis for exact comparisons.

Fix overlapping fills and other common problems

Overlap is the most common drawback of a filled radar chart. When one series covers another, the hidden series may appear smaller or may be difficult to identify. Try these remedies before adding more formatting:

  • Use fewer series in one chart. Separate charts can be clearer when there are many products, people, or time periods.
  • Increase transparency and give each series a distinct outline.
  • Switch to Radar with Markers or standard Radar when the line shapes matter more than the filled areas.
  • Use Chart Design > Select Data to change the series order; the order can affect which filled shape is visually on top.
  • Check that category order and axis bounds are consistent across charts being compared.

If Excel fills the wrong shape or creates an unexpected number of series, inspect the selected data range and the row/column orientation. If the chart looks blank, confirm that the values are numeric rather than text and that the series were included. If only the background changes when you choose a color, you probably selected the chart area or plot area rather than a data series. Select the colored polygon or the series name in the legend, then open Format Data Series.

When to use filled radar instead of another chart

Excel offers three closely related radar types: Radar draws lines, Radar with Markers adds a marker at each category, and Filled Radar colors the enclosed series areas. Use the line version when several series overlap or when readers need to follow each category’s exact point. Markers can make individual observations easier to locate. Filled Radar is most suitable when there are only a few series and the overall profile is the main point.

For values across a continuous sequence, such as monthly sales, a line chart is usually easier to read because its horizontal axis preserves the sequence. For a small number of categories where readers need to compare individual values, a bar or column chart often makes differences clearer. A radar chart is most useful when the categories form a meaningful set of dimensions and the reader wants to compare profiles across those dimensions.

Make the finished chart easier to read

Give the chart a descriptive title and name the measurement scale. A title such as Customer Support Ratings by Product tells readers more than Radar Chart. Keep category labels short enough to fit around the perimeter, and use a legend with series names that readers can distinguish without referring to a separate table.

Check the chart at its final display size. Labels that look fine on a large screen may crowd together in a report or slide. If category names are long, abbreviate them consistently and explain abbreviations nearby. Avoid decorative gradients or several unrelated effects: they can make the filled areas harder to compare without adding useful information. For an accessible chart, use sufficient contrast, retain readable labels, and provide the data in a table or nearby text for readers who cannot interpret the visual.

Frequently Asked Questions

How do I fill only one radar chart series?

Use the Filled Radar chart type, select the specific series by clicking its area or legend entry, and open Format Data Series > Fill & Line > Fill. Apply the color and transparency to that series. Repeat for other series only if you want them filled or differently styled.

Can I fill a regular radar chart without changing its chart type?

For the standard filled polygon effect, change the chart type to Filled Radar. A regular Radar chart is designed to show lines, so changing the chart or plot background is not the same as filling the data area.

Why can’t I see the series underneath another fill?

Opaque filled series can cover one another. Increase fill transparency, use distinct outlines, or reduce the number of series. You can also change the series order through Chart Design > Select Data, or use a line radar chart when overlap remains confusing.

Can I change the color of just the chart background?

Yes. Select the chart area or plot area rather than a series and use its formatting options to change the background. The chart area surrounds the whole chart, while the plot area is the region where the axes and data appear. Neither setting fills the polygon made by a data series.

Is a bigger filled area always a better score?

No. The area depends on the values, category scales, and shape of the series, so it is not automatically a valid overall rating. Compare the actual values and define a scoring method separately if you need one combined result.

Related

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.