How to Make a Radar Chart

Updated April 17, 2017

A radar chart is a graphical method for displaying tabular (arranged in rows and columns) data. A radar chart is also known as a spider chart due to its resemblance to a spider web. The chart consists of a centre point with spokes, or radii, spreading out. Each radius represents a row of the data. The plotted information is the data of your spreadsheet, grouped by column headings. A radar chart is used for identifying dominating variables, commonality and outlying data.

Select the data you wish to display in the radar chart. Left-click your mouse and drag over your data. Be sure to include the header and row titles.

Select "Insert" from the toolbar at the top of the screen, then "Other Charts" from the "Charts Group." The other chart icon should resemble a doughnut, or capital "O."

Choose one of the radar charts from the pop-up box. There are three chart types that all have the same functionality, just a slight variation in the format.

a. Radar -- The standard radar chart.

b. Radar with Markers -- The standard radar chart with markers to identify plot points and their values.

c. Filled Radar -- A radar chart that fills in each variable with a colour.


Play around with the formatting and style options in the "Chart Tools" menu to modify the presentation of your radar chart. If you are using Microsoft Windows, you should be able to select all of your data by pressing "Ctrl+A."

Things You'll Need

  • Excel 2007
  • Data arranged in a table
Cite this Article A tool to create a citation to reference this article Cite this Article

About the Author

Based in Orlando, Fla., David Parker has more than 15 years of technical and business experience. He has worked in project management and strategy with corporations such as AT&T, Cingular Wireless and Houghton Mifflin Harcourt. Parker earned a Bachelor of Science in business management from Troy University.