How to Create and Customise Radar Charts in Microsoft Excel

Evaluating multi-dimensional datasets—such as comparing employee competency ratings across multiple skills, benchmarking competing software products across features, or analysing athlete fitness tests across strength, endurance, and agility—can be difficult using standard column or line charts. When comparing multiple performance metrics evaluated on common scales, a Radar chart (also known as a spider chart, web chart, or star chart) provides an intuitive circular format.

In Microsoft Excel, a Radar chart plots data values along separate axes that originate from a central point and radiate outward like spokes on a bicycle wheel. A continuous line connects the data points for each category series, producing an enclosed polygon. By comparing the shapes, overlaps, and surface areas of these polygons, stakeholders can evaluate overall strengths, weaknesses, and balance across multiple metrics simultaneously. In this guide, you will learn how to structure data for Radar charts in Microsoft Excel, insert the chart from the ribbon, customise gridlines and axis scales, and apply filled polygon styling.

Understanding Radar Chart Types in Excel

Microsoft Excel offers three distinct variations of Radar charts:

• Standard Radar: Connects data points with lines along radiating value axes without markers. Ideal for comparing two or three distinct series cleanly.
• Radar with Markers: Adds visual marker bullets to each data point along the radial spokes, improving precise value identification.
• Filled Radar: Fills the area enclosed by the data series with semi-transparent solid colours, emphasizing total coverage and polygon size comparisons.

Preparing Data for a Radar Chart

To ensure Excel constructs radial spokes and series polygons accurately, structure your data in a clear tabular grid:

1. Column A (Dimensions / Metrics): Enter the evaluated attributes along the rows (e.g., Speed, Accuracy, Endurance, Teamwork, Problem Solving). Aim for 5 to 8 distinct dimensions; fewer than 3 lacks radial utility, while more than 10 can create visual clutter.
2. Header Row (Series Names): Enter the entities being compared across the top columns (e.g., Candidate A, Candidate B, or Benchmark Target).
3. Consistent Numeric Scale: Ensure all metrics share a normalised scale (e.g., ratings from 1 to 10, or percentages from 0% to 100%). Mixing incompatible scales (such as annual salary in thousands alongside a 1–5 star rating) distorts the polygon shape.

How to Create a Radar Chart in Microsoft Excel

Once your table is structured, generating the chart takes seconds:

1. Select your data range including headers (e.g., A1:C7).
2. Click the Insert tab on the Excel ribbon.
3. In the Charts command group, click the Waterfall, Funnel, Stock, Surface, or Radar Chart icon.
4. Under the Radar group, select Radar with Markers or Filled Radar.
5. Excel immediately plots the chart on your worksheet, rendering each row label as an outward spoke and each column as a connected data polygon.

Customising and Formatting Radar Charts

Default Radar charts often require visual adjustments to optimize executive readability:

1. Standardising the Radial Value Axis Scale

Excel sometimes sets the central axis scale automatically based on the highest data point. To maintain a standardized scale across audits:

1. Double-click the numeric values running along the vertical spoke to open the Format Axis pane.
2. Under Axis Options > Bounds, set the Minimum bound to 0.
3. Set the Maximum bound to your maximum test rating (e.g., 10 or 100).
4. Set Major Units to sensible intervals (e.g., 2 or 20) to draw clean concentric web rings.

2. Formatting Series Lines and Fills

1. Right-click any series polygon and select Format Data Series.
2. Under Fill & Line, adjust line width (e.g., 2.25 pt) and choose high-contrast colours.
3. If using Filled Radar, set the Transparency slider to roughly 50%. This prevents the front polygon from completely obscuring the series polygon positioned beneath it.
4. Under the Marker tab, customise marker size and colour to make spoke intersections crisp.

3. Adjusting Web Gridlines

The concentric rings can be circular or polygon-shaped:

1. Select the concentric gridlines within the chart plot area.
2. In the Format pane, choose whether to display subtle dashed or solid concentric lines.
3. Ensure gridline colour is set to light grey to keep the focus squarely on the coloured data series.

Radar Charts vs Other Comparison Charts

Visual Chart	Best Used For	Limitation
Radar Chart	Holistic comparison of multi-trait profiles (skills, features, fitness).	Difficult to read with more than 3 series or differing units.
Clustered Column	Exact numerical comparisons across categories.	Fails to convey holistic “balance” or overall shape profile.
Scatter / Bubble	Showing relationships and correlations between two or three numeric variables.	Cannot easily plot subjective categorical rating dimensions.

Best Practices for Interpreting Radar Charts

To draw sound conclusions from your Excel Radar visualisations:

• Look for Symmetrical Balance: A balanced, well-rounded performer or product produces an even, symmetrical polygon, whereas a specialised candidate produces skewed spikes.
• Limit Compared Series: Avoid plotting more than three entities simultaneously on one chart. Overlapping multiple filled polygons creates confusing visual noise.
• Overlay a Target Benchmark: Include an ideal “Target” series with a dashed line; this makes it immediately apparent which competencies fall short of organizational expectations.