How to Make a Radar Chart in Excel (2026 Guide)
Home›Excel Charts›Make a Radar Chart
ExcelHow-To⏱ 2 min read

How to Make a Radar Chart in Excel (2026)

Radar charts (also called spider charts) compare entities across multiple attributes on a single visualization. Perfect for skill assessments, product feature matrices, and team performance dashboards. This guide covers the build, formatting, and when radar charts actually work.

⚡ Quick Answer

Attributes as rows, entities as columns. Select data. Insert tab → Radar chart icon → pick basic Radar or Filled Radar. Normalize your data first if attributes are on different scales.

Step 1: Set up your data

Attributes as row labels, entities to compare as columns:

Skill              Alice   Bob   Carol
Communication         9      6      8
Technical             7     10      6
Leadership            8      5      9
Problem-solving       6      9      7
Teamwork              9      7      8
Adaptability          7      8      9
Normalize your scales first

Radar charts assume attributes share a scale. If "revenue" is in millions and "customer satisfaction" is a 1-10 rating, the chart will be dominated by the bigger number. Normalize everything to a common scale (0-10 or 0-100) before charting.

Step 2: Insert the radar chart

  1. Select the data

    Include headers and all rows.

  2. Insert tab → Waterfall/Stock/Surface/Radar icon

    Radar is under this multi-icon dropdown, or in "All Charts" tab of Recommended Charts.

  3. Pick a variant

    Three options: basic Radar, Radar with markers, Filled Radar.

  4. Click to insert

    Chart appears with axes radiating from center.

Radar chart variants

Basic Radar

Outline shape only. Best for comparing 3-4 entities where overlapping fills would be a mess.

Radar with markers

Outline plus a marker at each attribute point. Best for precise reading of specific attribute values.

Filled Radar

Enclosed area filled with color. Visually striking for a single entity or two entities. With 3+ entities, filled radars get muddy — outlines are better.

Formatting

Adjust axis scale

Right-click any axis label → Format Axis. Set minimum to 0 and maximum to your max attribute value (e.g., 10 for a 1-10 rating scale). Fixed axis makes multi-radar comparisons fair.

Reduce visual noise

  • Delete unnecessary gridlines — often just the outermost circle is needed
  • Remove the chart border and background fill
  • Use one color per entity with medium transparency (30-40% fill for filled radars)

Legend placement

Radar charts benefit from a strong legend since entity identification isn't intuitive. Place at the bottom or right. Use bold entity names in legend text.

Common radar use cases

Skill assessments

Employee vs. team average across attributes. Fills gaps ("Carol is strong on leadership but weak on technical") faster than a bar chart.

Product feature comparison

Your product vs. two competitors across features. Filled radar with 30% transparency lets differences show through.

Team performance dashboards

Sales team members across metrics (calls, meetings, revenue, deal size). Highlights strengths and gaps.

Personality/style assessments

Myers-Briggs, DISC, or custom competency frameworks. Radars visualize the "shape" of a person.

Consumer product decision matrices

Reviewing options with multiple criteria (price, quality, features, service). Radar makes multi-attribute reasoning visual.

When radar charts fail

Too many entities

4+ entities on one radar becomes visual soup. Split into small multiples (one radar per entity in a grid) or switch to a heatmap-style table.

Too few or too many attributes

Below 3 attributes, radars have no advantage over bar charts. Above 8, individual attribute values become hard to read. Sweet spot: 4-8 attributes.

Attributes not on the same scale

Never chart raw revenue and satisfaction scores together. Normalize everything first, or use a bar chart.

Attribute order matters

Radar charts visually cluster adjacent attributes. Order attributes deliberately — related ones next to each other so the shape tells a story. Alphabetical order rarely does.

Excel Wizard

Multi-attribute analysis without the setup

Radar charts need normalized data and thoughtful attribute ordering — both easy to skip. Excel Wizard can normalize your data, suggest attribute grouping, and build the chart with the right variant for how many entities you're comparing.

Install Excel Wizard →

Frequently asked questions

How do I make a radar chart in Excel?

Set up your data with attributes as rows and entities as columns. Select the range including headers. Insert tab → Radar chart icon → pick basic Radar, Radar with markers, or Filled Radar.

When should I use a radar chart?

Use radar charts for multi-attribute comparison — comparing a small number of entities (2-4) across 4-8 dimensions. Common uses: skill assessments, product feature comparison, team performance metrics.

What's the difference between radar and filled radar?

Radar shows just the outline. Filled radar fills the enclosed area with color. Filled is more striking but harder to read with multiple entities overlapping. Use plain radar (with markers) for multi-entity comparison; filled for single-entity showcases.

Why does my radar chart look distorted?

Radar charts assume all attributes are on the same scale. If one attribute ranges 0-10 and another ranges 0-1000, the chart is dominated by the larger scale. Normalize your data (all attributes 0-100 or 0-10) before charting.