A radar chart (also called a spider chart) is one of the quickest ways to compare several items across the same set of categories. Here’s how to make one in Excel.
Step 1: Lay out your data
Put your categories in the first column and each item’s values in the columns beside them. For example, categories like Speed, Power, and Range down column A, with one item per following column.
Step 2: Select your data
Highlight the full range, including the category labels and the header row.
Step 3: Insert the radar chart
Go to Insert → Charts → Other Charts → Radar. Excel offers three variants: plain radar, radar with markers, and filled radar. Pick the one that reads most clearly for your data.
Step 4: Clean it up
Adjust the axis scale so the shape uses the full area, tidy the labels, and give the chart a title. Right-click the axis to set a fixed maximum if Excel’s auto-scaling looks cramped.
A faster way: make an animated radar chart online
Excel’s radar charts are static images. If you want something you can drop into a slide deck, a social post, or a web page — and have it animate — you can skip Excel entirely.
Use our free Radar Chart Maker: type in your data, and export a PNG or an animated GIF or video. No Excel, no sign-up, and it works on your phone.