While working with **Microsoft Excel**, when we want to display demographic or regional capacity information, we may use the **Radar Chart**. This represents multidimensional data in a two-dimensional chart using this style of graphic. And, the **standard deviation** is significant because it reveals the degree of dispersion of a dataset’s values. But likewise, the other excel charts do not have any default feature to include the standard deviation in the radar chart. In this article, we will demonstrate the procedures to include standard deviation in **Excel radar charts**.

**Download Practice Workbook**

You can download the workbook and practice with them.

**What Is Standard Deviation?**

In statistics, the standard deviation is a crucial indicator of central tendency and dispersion. The standard deviation is calculated using the formula below:

One of the values is the mean or average of the numbers, and **n** is the overall sample size in this calculation. The standard deviation is a measurement of how much each value in a sample deviates from the average. It is the square root of the variance, in a nutshell. The average of a dataset is a squared variation from the mean or average is called **variance**.

**Step-by-Step Procedures to Include Standard Deviation in Excel Radar Chart**

Radar charts are employed to compare two or more objects or groups based on a variety of traits or qualities. And, we utilize the standard deviation to assess estimating mistakes. We can enable error bars in charts where a standard deviation is a default option. Excel enables you to add error bars to the following charts if you wish to display, for instance, standard deviations in a chart:

**2D Area Diagram****Bar Chart****Column Chart****Line Graph****X and Y Scatter Plot****Bubble Chart**

But, we can not enable standard deviation on radar charts. Still, we can include standard deviation in the radar chart by using excel functions. Let’s follow the instructions to add standard deviation in the excel radar chart.

**Step 1: Create Dataset for Excel Radar Chart**

First, we need to create a dataset. As we know, the datasets are the continuous cell range holding data for analysis.

- To begin with, we insert some
**Sample**data;**A**,**B**,**C**,**D**,**E**, and**F**in column**B**. - Then, suppose we put some tests on those sample data. And keep the record of the test result in
**Test 1**and**Test 2**, subsequently in columns**C**and**D**.

**Read More: How to Create Excel Radar Chart with Different Scales**

**Step 2: Excel STDEV.P Function to Calculate Standard Deviation**

Now, we will calculate the standard deviation in our dataset to include them in the radar chart. The standard deviation of any data collection can be calculated using **the STDEV function** in excel. The standard deviation displays how far one value differs from another in terms of digits.

Here, we will use **the STDEV.P function** in excel which estimates the standard deviation for a collection of data in a sample. **STDEV.P** uses the “**n**” method to calculate standard deviation, ignoring logical values and text. The main purpose of the **STDEV.P** function is to get the standard deviation of the population.

Let’s look at the sub-procedures to add standard deviation in the dataset to include the standard deviation in the excel radar chart.

- Firstly, we insert a new column into our dataset to calculate the standard deviation.
- Secondly, select the cell where we input our formula. In our case, we select cell
**E5**. - Thirdly, type the formula into that selected cell.

`=STDEV.P(C5:D5)`

- Further, press
**Enter**to see the result.

- After that, drag the
**Fill Handle**down to duplicate the formula over the range. Or, to**AutoFill**the range,**double-click**on the plus (**+**) symbol.

- Thus, we can see the result of the standard deviation of all the samples.

**Read More: Plot Normal Distribution in Excel with Mean and Standard Deviation**

**Similar Readings**

**How to Calculate Standard Deviation of a Frequency Distribution in Excel****How to Find Outliers with Standard Deviation in Excel (with Quick Steps)**

**Step 3: Insert Radar Chart in Excel**

A chart can provide a sharper view of a set of data values. Now, we will insert a radar chart. It enables us to understand the characteristics of two or more variables and determine whether they are connected or disconnected.

- First of all, select the whole dataset.
- Then, go to the
**Insert**tab from the ribbon. - After that, under the
**Charts**category, click on the**Insert Waterfall, Funnel, Stock, Surface or Radar Chart**drop-down menu. - Next, select
**Radar with Markers**which is the**2nd**option under the**Radar**group.

- This will display the
**Standard Deviation**radar chart.

**Note: **You can customize the chart as per your requirement. For this, go to **Chart Design **which you can find in the ribbon after clicking on the chart area.

**Read More:** **How to Create a Bell Curve with Mean and Standard Deviation in Excel**

**Final Output**

This is the final chart after including the standard deviation in the excel radar chart. The gray spider/radar chart portion is the standard deviation in the radar chart.

**Things to Keep in Mind**

- Radar charts never attempt to compare more than three groups. Additionally, avoid trying to show more than ten aspects on one radar. Make sure there are no more than two variables being used. If not, it will be difficult for a user to comprehend and draw conclusions.
- The data must be arranged schematically.
- To prevent having too many intervening axis values, work on-axis values.
- To make the spider web larger, legends should be removed; nevertheless, legends may be added by adding shapes.
- One of the simplest things to change to make the chart easier to read is the text’s size. In the ‘
**Formatting**’ section, complete all of them.

**Conclusion**

The above procedures will assist you in** Excel**. Hope this will help you! Please let us know in the comment section if you have any questions, suggestions, or feedback. Or you can glance at our other articles in the **ExcelDemy.com** blog!

**Related Articles**

**How to Calculate Mean Variance and Standard Deviation in Excel****Generate Random Number with Mean and Standard Deviation in Excel****How to Calculate Average and Standard Deviation in Excel****How to Calculate/Find Mean and Standard Deviation in Excel****Color Rings on Radar Chart in Excel (4 Suitable Examples)**