To draw a radar chart in Microsoft Excel, arrange your categories in the first column and each data series in its own column, select the whole table, then choose Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart > Radar. Pick a radar style and format the chart so the values and series are easy to compare. Radar charts work best for comparing a few items across the same set of measures.
What You’ll Need
- Microsoft Excel for Microsoft 365 on Windows. The steps below use the desktop ribbon; Excel for Mac has similar chart options, though ribbon placement and wording can vary slightly.
- A small, rectangular table with text labels for categories and numeric values for each item you want to compare.
- Measures that use the same scale, or have been converted to a comparable scale. A radar chart can be misleading when one category is measured in percentages and another in thousands of dollars.
Step-by-Step
- Lay out the data. Put the category names down the first column, with one category per row. Put each item, person, product, or time period you want to compare in a separate column, and give each series a clear heading. For example, A1 can be blank or say Measure, B1 can say Product A, and C1 can say Product B. Enter criteria such as Speed, Comfort, Price, and Reliability in A2:A5, then enter the corresponding numeric ratings under each product heading. Use one consistent rating scale, such as 1 through 5. Avoid blank rows and columns inside the table.
- Check that Excel can interpret the table. Make sure the headings are text and the measurements are numbers, not numbers stored as text. Each category should have a value for every series. Radar charts need categories around the chart and one or more series plotted against them; missing values can leave gaps or produce confusing shapes. Keep the table compact: four to eight categories and a few series are usually easier to read than a chart with dozens of spokes or lines.
- Select the chart data. Drag across the full table, including the row of series headings and the column of category labels. In the example, select A1:C5. Including headings helps Excel create a legend and label the spokes correctly. If your table is larger, select only the range containing the intended data rather than entire worksheet columns, which can make chart creation harder to manage.
- Insert a radar chart. On the ribbon, select Insert > Insert Waterfall, Funnel, Stock, Surface or Radar Chart. In the Radar section of the menu, choose Radar, Radar with Markers, or Filled Radar. Radar draws lines between values, Radar with Markers adds a marker at each category, and Filled Radar shades the area enclosed by each series. For a first comparison, Radar with Markers is often a useful choice because the individual category values are visible. Filled Radar can be harder to read when series overlap.
- Confirm the series and category orientation. Excel usually places the first-column labels around the chart and treats each later column as a separate series. If the chart instead has the wrong number of spokes or compares categories as separate series, select the chart and go to Chart Design > Switch Row/Column. Check that the legend lists the items you intended to compare and that the category labels around the perimeter are correct. Use Switch Row/Column again if the change makes the layout less accurate.
- Choose a suitable radar style. Click the chart, then use Chart Design > Change Chart Type if you want to switch among Radar, Radar with Markers, and Filled Radar after insertion. In the Change Chart Type window, select Radar and choose the desired subtype. You can also use Chart Design > Change Colors to select a coordinated palette. Prefer clearly distinct line colors and avoid relying on color alone when the chart will be printed in grayscale.
- Add a useful title and labels. Select the chart title and type a concise description, such as Product Ratings by Attribute. If the chart has no title, use Chart Design > Add Chart Element > Chart Title and choose a title position. To show the actual values at points, use Chart Design > Add Chart Element > Data Labels and select a position. Labels can clutter a chart with multiple series, so add them only when readers need exact values rather than a visual comparison.
- Set the value scale and tidy the layout. The concentric rings represent the value axis. Right-click a value-axis label and choose Format Axis to open the formatting pane. Under Axis Options, review the minimum, maximum, and major unit bounds. Excel may set these automatically; set a fixed minimum and maximum when every chart in a report must use the same scale. For ratings from 1 to 5, for instance, a 0-to-5 scale can make the visual comparison consistent, but it may visually compress differences. Keep the scale honest and clear. Resize the chart by dragging a corner handle, and move the legend or remove unnecessary elements using Chart Design > Add Chart Element.
Common Mistakes
Mixing incompatible scales: If one spoke ranges from 0 to 5 and another from 0 to 100, the larger-number measure can dominate the visual pattern. Convert measures to a common, meaningful scale before charting, or make separate charts. Do not rescale values without documenting what the new numbers mean.
Adding too many categories or series: Every category adds a spoke, and every series adds another line or filled shape. A dense chart becomes difficult to decode, especially when colors overlap. Select the few measures that matter most, or split the data into multiple charts.
Leaving out labels or selecting an incomplete range: If the series headings are excluded, the legend may show generic names. If the category labels are excluded, Excel may display numbered spokes. Re-select the chart and use Chart Design > Select Data to check the chart data range and series names.
Using Filled Radar for many comparisons: Filled areas obscure one another and can suggest that overlapping values are separate totals. Use regular Radar or Radar with Markers for several series, and reserve Filled Radar for a small number of comparisons where the overlap remains legible.
Tips
- Put related categories in a deliberate order. The chart connects categories in table order, so arrange them logically—for example, by workflow or by a meaningful sequence—rather than alphabetically by default.
- Keep category labels short. Long labels can wrap or crowd the chart. If necessary, abbreviate them in the chart source and explain the abbreviations in a note nearby.
- Use the same axis minimum and maximum when comparing radar charts side by side. Automatic scales may differ between charts, making similar shapes look more different—or different shapes look more similar—than they are.
- Use a data table or ordinary chart alongside the radar chart when readers need precise values. Radar charts are strongest at showing profiles and patterns, not at making exact comparisons between points on different spokes.
- For a report, add a short note that explains the scale and whether higher or lower values are better. This prevents readers from misreading a strong-looking shape when, for example, a low cost score is preferable.
Troubleshooting
The Radar chart option is missing or unavailable: First select a normal cell range containing labels and numeric data, then open the Insert tab and look in the chart-type menu. If the workbook is in Compatibility Mode or an older file format, save a copy as an Excel workbook (.xlsx) and try again. In Excel for Mac, look on the Insert tab for the chart insertion controls; the exact menu grouping can differ from Windows.
The chart shows the wrong labels or series: Select the chart and choose Chart Design > Select Data. In the Select Data Source dialog, confirm the chart data range, the series names, and the horizontal (category) axis labels. Correct the range if it includes extra cells, then use Switch Row/Column if Excel has interpreted rows and columns in the opposite way from what you intended.
The chart is blank or some values are missing: Check that the selected range contains numeric values and that numbers are not stored as text. Look for blank cells, formulas returning an empty text string, or error values in the source. Replace or correct those entries as appropriate, then verify that the chart data range includes the corrected cells. If the source is on another sheet, confirm that the selected range still points to the intended sheet and cells.
The lines are difficult to compare: Remove unnecessary series, switch from Filled Radar to Radar with Markers, and use distinct colors. Check the axis bounds in Format Axis; automatic bounds can make small differences appear dramatic. If the chart remains crowded, use separate charts or a data table instead of shrinking the labels until they are unreadable.
Frequently Asked Questions
What is a radar chart used for?
It compares multiple items across the same set of categories, displaying each item as a profile around a circular set of axes. Common examples include product ratings, skill assessments, and performance measures that share a scale.
What is the difference between Radar and Radar with Markers?
Both connect the category values with lines. Radar with Markers adds a visible point at each category, which helps readers identify where each measurement falls. Choose it when you want category-by-category values to stand out.
Can I make a radar chart with negative values?
Radar charts are generally intended for nonnegative measures with a meaningful shared scale. Negative values may be difficult to interpret around the circular axes. If your data includes negatives, consider a line or bar chart that makes the zero point easier to see.
Can I change the order of the spokes?
Yes. Change the order of the category rows in the source table, and the chart will follow that order. If the data is arranged for other purposes, make a separate, clearly labeled chart data range in the order you want to display.
Can I create a radar chart in Excel for the web?
Excel for the web supports many chart tasks, but available chart options and formatting controls may vary. If you cannot find the Radar chart type or a formatting control, open the workbook in Excel for Microsoft 365 on Windows or Mac and make the change in the desktop app.
Related
- How to Delete Highlighted Cells in Excel
- Delete a Hidden Row in Excel: Safe Steps That Work
- How to Delete Gridlines in Excel for a Cleaner Sheet
Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.
More in Charts & pivot tables
- Google Sheets Pivot Tables: Combine Multiple SheetsGoogle Sheets pivot tables use one source range, so they cannot directly summarize separate tabs as independent sources.…
- Excel Pivot Table: Show Unique Values Without RepeatsYes. To show each distinct item once in an Excel PivotTable, drag its field into the Rows area;…
- Create a Custom Combo Chart in ExcelTo create a custom combo chart in Excel for Microsoft 365 on Windows, select your category labels and…
- Access Power Pivot in Excel 365: Enable and Use ItTo access Power Pivot in Excel for Microsoft 365 on Windows, open File > Options > Add-ins, choose…
- Excel Mini Chart in Cell: Add and Format SparklinesIn Excel, a mini chart displayed in a worksheet cell is called a sparkline. In Excel for Microsoft…
- Org Chart Template for Google SheetsTo make an org chart in Google Sheets, put each person or position in column A and that…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.