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.
- Skill level:
Other People Are Reading
Things you need
- Excel 2007
- Data arranged in a table
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.
Tips and warnings
- 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."
- 20 of the funniest online reviews ever
- 14 Biggest lies people tell in online dating sites
- Hilarious things Google thinks you're trying to search for