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
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
Select the data
Include headers and all rows.
Insert tab → Waterfall/Stock/Surface/Radar icon
Radar is under this multi-icon dropdown, or in "All Charts" tab of Recommended Charts.
Pick a variant
Three options: basic Radar, Radar with markers, Filled Radar.
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
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.
Below 3 attributes, radars have no advantage over bar charts. Above 8, individual attribute values become hard to read. Sweet spot: 4-8 attributes.
Never chart raw revenue and satisfaction scores together. Normalize everything first, or use a bar chart.
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.
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.