A radar chart (also known as a spider chart) are used to plot one or more groups of values over multiple common variables. They are useful when you cannot directly compare the variables and is especially great for visualizing performance analysis or survey data.
This tutorial will show you how to make and edit a Radar Chart in Excel
Use your mouse to select the data you would like to include in your Radar Chart (holding down the control key allows non-contiguous ranges of data to be selected).
After selecting the data for the chart, click on the Insert tab and select waterfall choice from the charts group.
Click the appropriate Radar Chart option from the Insert Waterfall, Funnel, Stock, surface or Radar panel, then the chart will appear in the workbook.
There are currently three options available: Radar, Radar with markers, and Filled Radar. Each allows information to be displayed a little differently. Radar is the default in Excel. Radar with markers makes the data points easier to read. Finally Filled Radar focuses attention on the areas in between the lines.
You will now see your area chart appear in your worksheet. Now you can start adding chart elements and formatting to your chart. Continue reading for more details on adding chart elements and chart formatting.
Use the cursor to click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted. Once you see the border appear around the chart, then you know the chart editing features are enabled.
Once the chart name area is highlighted, you will see the Chart Elements button next to upper right hand side of the chart. The button looks like a plus sign. Doing this will open the Chart Elements window.
Once you have opened the Chart Elements window, you will see a number of items you can select to add to your chart. Check the Chart Elements you would like to display and they will appear on your chart. You can click on the arrow next to each Chart Element option for some additional formatting options.
Here are the available chart elements for a Radar Chart:
Each of these chart elements can be formatted in a variety of ways. Please see our other tutorials on how to add and format each chart element.
Use the mouse to right-click on a blank area on your chart. On the menu that appears select the Format Chart Area option.
On the menu that appears select the Format Chart Area option. Doing this will open the Format Chart Area panel on the right side of the workbook.
Once you have opened the Format Chart Area panel, you will see a number of items you can modify on your chart. use these features to create a custom look for your Radar chart.
Here are the available chart elements for a Radar Chart:
Please note: You can also right click on any of your chart elements and open a separate formatting panel for that particular item. The Format Chart Area panel will be the one you want to use when formatting the main structure of the chart.
Use the cursor to click on a blank area on your chart. Make sure to click on a blank area in the chart. The border around the entire chart will become highlighted. Once you see the border appear around the chart, then you know the chart editing features are enabled.
Once the chart name area is highlighted, you will see the Chart Filters button next to upper right-hand side of the chart. The button looks like a plus sign. Doing this will open the Chart Filters window
Once you have opened the Chart Filters window, you will see a number of items you can select to add to your chart. Check the Chart Filters you would like to display and they will appear on your chart.
Topic #13
How to Make a Treemap Chart in Excel
Thanks for checking out this tutorial. If you need additional help, you can check out some of our other free Excel Chart Tutorials, or consider taking an Excel class with one of our professional trainers.
Guide Topics