Present your data in a radar chart

A radar chart, also known as a spider chart or a star chart because of its appearance, plots the values of each category along a separate axis that starts in the center of the chart and ends on the outer ring.

Filled radar chart

In this article

Learn more about plotting data in a radar chart

Create a radar chart

Save a chart as a template

Learn more about plotting data in a radar chart

Data that is arranged in columns or rows on a worksheet can be plotted in a radar chart. Radar charts compare the aggregate values of multiple data series.

Radar charts include the following chart subtypes:

  • Radar and radar with markers    With or without markers for individual data points, radar charts display changes in values relative to a center point.

    Radar and Radar with Markers chart type

  • Filled radar    In a filled radar chart, the area covered by a data series is filled with a color.

    Filled radar chart type

Top of Page

Create a radar chart

Filled radar chart

So, how did we create this radar chart? The following procedure will help you create a radar chart with similar results. For this chart, we used the example worksheet data. You can copy this data to your worksheet, or you can use your own data.

  1. Copy the example worksheet data into a blank worksheet, or open the worksheet that contains the data that you want to plot in a radar chart.

    How to copy the example worksheet data

    1. Create a blank workbook or worksheet.

    2. Select the example in the Help topic.

      Note   Do not select the row or column headers.

      Selecting an example from Help
      Selecting an example from Help
    3. Press CTRL+C.

    4. In the worksheet, select cell A1, and press CTRL+V.

1

2

3

4

5

6

7

8

9

10

11

12

13

A

B

C

D

E

Bulbs

Seeds

Flowers

Trees & shrubs

Jan

0

2500

500

0

Feb

0

5500

750

1500

Mar

0

9000

1500

2500

Apr

0

6500

2000

4000

May

0

3500

5500

3500

Jun

0

0

7500

1500

Jul

0

0

8500

800

Aug

1500

0

7000

550

Sep

5000

0

3500

2500

Oct

8500

0

2500

6000

Nov

3500

0

500

5500

Dec

500

0

100

3000

  1. Select the data that you want to plot in the radar chart.

  2. On the Insert tab, in the Charts group, click Other Charts.
    Excel Ribbon Image

  3. Under Radar, click Filled Radar.

  4. Click the chart area of the chart.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  5. On the Design tab, in the Chart Styles group, click the chart style that you want to use.
    Chart Styles group on Excel Ribbon

    Tip   For our radar chart, we used Style 26.

  6. To change the size of the chart, on the Format tab, in the Size group, select the shape size that you want in the Shape Height and Shape Width boxes, and then press ENTER.

    Tip   For our radar chart, we used 3 for the shape height and 4 for the shape width.

    Outlook Ribbon Image

    1. To add, format, and position a chart title in the chart, click the chart area, and then do the following:

      1. On the Layout tab, in the Labels group, click Chart Title, and then click Above Chart.

        Excel Ribbon Image

      2. In the chart, click the chart title, and then type the text that you want.

        Tip   For our radar chart, we typed Garden Center Sales.

      3. To reduce the size of the chart title, right-click the title, and then enter the size that you want in the Size box on the shortcut menu.

        Tip   For our radar chart, we used 12.

    2. To remove the axis labels, click the vertical axis, or select it from a list of chart elements (Layout tab, Current Selection group, Chart Elements box).

    3. On the Format tab, in the Current Selection group, click Format Selection.

    4. Under Axis Options, in the Axis labels box, click None.

    5. If you want to use theme colors that are different from the default theme that is applied to your workbook, do the following:

      1. On the Page Layout tab, in the Themes group, click Themes.

        Excel Ribbon Image

      2. Under Built-in, click the theme that you want to use.

        Tip   For our radar chart, we used the Office theme.

Top of Page

Save a chart as a template

If you want to create another chart like the one that you just created, you can save the chart as a template that you can use as the basis for other similar charts.

  1. Click the chart that you want to save as a template.

  2. On the Design tab, in the Type group, click Save as Template.

    Excel Ribbon Image

  3. In the File name box, type a name for the template.

    Tip    Unless you specify a different folder, the template file (.crtx) will be saved in the Charts folder, and the template becomes available under Templates in both the Insert Chart dialog box (Insert tab, Charts group, Dialog Box Launcher Button image) and the Change Chart Type dialog box (Design tab, Type group, Change Chart Type).

    For more information about how to apply a chart template, see Reuse a favorite chart by using a chart template.

Note   A chart template contains chart formatting and stores the colors that are in use when you save the chart as a template. When you use a chart template to create a chart in another workbook, the new chart uses the colors of the chart template — not the colors of the document theme that is currently applied to the workbook. To use the document theme colors instead of the chart template colors, right-click the chart area, and then click Reset to Match Style on the shortcut menu.

Top of Page

Applies To: Excel 2007, Outlook 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language