Excel Functions Tutorials
- Excel Formulas Cheatsheet
- Financial Functions in Excel
- Logical Functions in Excel
- TEXT Functions in Excel
- Char Function In Excel
- CLEAN Excel Function
- CODE Excel Function
- Concatenate Excel Function
- EXACT Excel Function
- FIND Function in Excel
- LEFT Function in Excel
- LEN in Excel
- MID in Excel
- PROPER in Excel
- REPT Function in Excel
- RIGHT Function in Excel
- Search Function in Excel
- Substitute Function in Excel
- Substring in Excel
- TEXT Function in Excel
- Trim in Excel
- VALUE Function in Excel
- Lookup Reference in Excel
- Address Function in Excel
- Choose Function in Excel
- Column Function in Excel
- Columns Function in Excel
- REPLACE Function in Excel
- GetPivotData in Excel
- HLOOKUP in Excel
- Hyperlink Excel Function
- INDIRECT Function in Excel
- LOOKUP Excel Function
- Match Excel Function
- VLOOKUP Excel Function
- INDEX Excel Function
- VLOOKUP vs HLOOKUP
- TRANSPOSE Excel Function
- Row Function in Excel
- OFFSET Excel Function
- VLOOKUP with Multiple Criteria
- IFERROR with VLOOKUP in Excel
- Fixing VLOOKUP Errors
- Alternatives to Vlookup
- Maths Functions in Excel
- ABS Function in Excel
- AGGREGATE Excel Function
- CEILING Excel Function
- COMBIN Excel Function
- COS Excel Function
- EVEN Function in Excel
- EXPONENTIAL Excel Function
- FLOOR Function in Excel
- INT Excel Function (Integer)
- LN Excel Function
- LOG Excel Function
- ODD Function in Excel
- POWER Function in Excel
- PRODUCT Excel Function
- RAND Excel Function
- ROUND in Excel
- ROUNDDOWN Excel Function
- ROUNDUP Function in Excel
- SIGN Excel Function
- SIN Excel Function
- Square Root in Excel (SQRT)
- SUBTOTAL Excel Function
- SUM Function in Excel
- SUMIF in Excel
- SUMPRODUCT Function in Excel
- TAN Excel Function
- TANH in Excel
- Date and Time Function in Excel
- Statistical Function in Excel
- AVERAGE Excel Function
- CORREL Excel Function
- Correlation vs Covariance
- COUNT Excel Function
- COUNTIF Excel Function
- COUNTIF with Multiple Criteria
- FORECAST Excel Function
- FREQUENCY Excel Function
- GROWTH Excel Function
- LARGE Excel Function
- LINEST Excel Function
- MAX Excel Function
- Mean vs Median
- MEDIAN Excel Function
- MIN in Excel
- MODE Excel Function
- NORM.S.INV Function in Excel
- NORMDIST in Excel
- PERCENTILE Excel Function
- QUARTILE Excel Function
- SLOPE Function in Excel
- SMALL Function in Excel
- Standard Deviation in Excel
- TREND Function in Excel
- T-TEST in Excel
- Variance vs Standard Deviation
- Information Functions in Excel
- Excel Charts
- Area Chart in Excel
- Bubble Chart in Excel
- Clustered Bar Chart in Excel
- Clustered Column Chart in Excel
- Column Chart in excel
- Combination Charts in Excel (Combo)
- Dynamic Chart in Excel
- Gantt Chart in Excel
- Gauge Chart in Excel (Speedometer)
- Histogram Excel Chart
- Pareto Chart in Excel
- Pie Chart in Excel
- Pivot Chart in Excel
- Radar Chart in Excel (Spider Chart)
- Stacked Chart in Excel (Column, Bar & 100% Stacked)
- Stacked Column Chart
- Waterfall Chart in Excel
- Excel Tools
- "Save As" Shortcut in Excel
- Accounting Number Format in Excel
- Add-Ins in excel
- Advanced Filter in Excel
- Auto Filter In Excel
- Auto Format Excel
- AutoFill in Excel
- Checkbox in Excel
- Combo Box in Excel and VBA
- Conditional Formatting in Excel
- Consolidate Data in Excel
- Data Bars in Excel
- Data Table in Excel
- Data Validation Excel
- Descriptive Statistics in Excel
- Dynamic Named Range in Excel
- Excel Fill Handle
- Excel Forms for Data Entry
- Excel Tables
- Exponential Smoothing in Excel
- Filters in Excel
- Flash Fill in Excel
- Freeze Panes in Excel
- F-Test in Excel
- Gridlines in Excel
- Header and Footer in Excel
- List Box in Excel VBA
- Lock Cells in Excel
- Merge and Center in Excel
- Merge Cells in Excel
- Name Range in Excel
- One Variable Data Table in Excel
- Paste Special in Excel (With Top 10 Shortcuts)
- Radio Button in Excel
- Recording Macros in Excel
- Regression Analysis in Excel
- Scenario Manager in Excel
- Scroll Bars in Excel
- Slicers in Excel
- Solver in Excel
- Sort by Color in Excel
- Sort by Number in Excel
- Sort Data in Excel
- Sparklines in Excel
- Spell Check in Excel
- Split Panes in Excel (Horizontally, Vertically, Cross Split)
- Status Bar in Excel
- Text to Columns in Excel
- Timeline in Excel
- Track Changes in Excel
- Two-Variable Data Table in Excel
- Watch Window in Excel
- Wrap Text in Excel
- Excel Tips
- 3D Reference in Excel
- Absolute Reference in Excel
- Array Formulas in Excel
- Arrays in Excel VBA
- Auto Numbering in Excel
- AutoFit in Excel
- CAGR Formula in Excel
- Calculate Age in Excel
- Calculate Percentage in Excel Formula
- Cell Reference in Excel
- Checklist in Excel
- Circular Reference in Excel
- Column Sort in Excel
- Combine Cells in Excel
- Compare Two Columns in Excel
- Concatenate Date in Excel
- Conditional Formatting Based on Another Cell Value
- Conditional Formatting in Pivot Table
- Convert Columns to Rows in Excel
- Convert Date to Text in Excel
- Convert Numbers to Text in Excel
- Convert Text to Numbers in Excel
- Count Characters in Excel
- Count Unique Values in Excel
- Custom Number Format in Excel
- Delete Row Shortcut in Excel
- Divide in Excel Formula
- Drop Down List in Excel
- Dynamic Tables in Excel
- Equations in Excel
- Excel Extensions
- Excel Find and Replace
- Excel Subtraction Formula
- Excel Table Styles & Formats
- Excel vs Google Sheets
- External Links in Excel
- Filter Shortcut in Excel
- Formatting in Excel
- Formula Errors in Excel
- Fractions in Excel
- Group Worksheets in Excel
- Hide Formula in Excel
- Hiding a Column in Excel
- Highlight Every Other Row in Excel
- How to Add Text in Excel Formula?
- How to Copy Sheet in Excel?
- How to Delete Pivot Table?
- How to Multiply in Excel Formula?
- How to Unhide Columns in Excel?
- Insert Hyperlinks in Excel
- Insert Multiple Rows in Excel
- Insert Row Shortcut in Excel
- Last Day of the Month in Excel
- Moving Average in Excel
- Not Equal to in Excel
- Numbering in Excel
- Personal Budget Template in Excel
- Print Comments in Excel
- Print Excel Gridlines
- Print in Excel
- Protect Sheet in Excel
- Random Numbers in Excel
- Randomize List in Excel
- Refresh Pivot Table in Excel
- Relative References in Excel
- Remove Blank Rows in Excel
- Remove Duplicates in Excel
- Remove Hyperlinks in Excel
- Remove Space in Excel
- Row Limit in Excel
- Rows to Columns in Excel
- Share an Excel Workbook
- Shortcut to Merge Cells in Excel
- Show Formula in Excel
- Split Cells in Excel
- Strikethrough in Excel
- Subscript in Excel
- Superscript in Excel
- Timesheet Calculator in Excel
- Top 20 Keyboard Shortcuts in Excel
- Unmerge Cells in Excel
- Uppercase in Excel
- Weighted Average in Excel
Excel Radar Chart (Table of contents)
- Radar Chart in Excel
- Different Types of Radar Chart in Excel
- How to Create Radar Chart in Excel?
- Advantages of using Spider chart
- Disadvantages of using Spider chart
What is Radar Chart in Excel (Spider Chart)
Radar chart in excel visualizes the performance and makes visible concentrations of strengths and weaknesses.
Radar Chart in Excel usually called as a “Spider Chart”, “Web Chart” as well. The spider chart in excel is a kind visualization in case of performance analysis of an employee, performance analysis of a student, satisfaction of a customer and other rating data across multiple categories in a single chart.
Different Types of Radar Chart in Excel
#1 Radar Chart
Display values relative to a center point. It is best used when the categories are not directly comparable. Given below is the example for this type of chart.
#2 Radar Chart with Markers
Very similar to the earlier type but the only difference is it has markers in each data points. Given below is the example for this type of chart.
#3 Radar Chart with fills (Filled Spider Chart)
Everything remains same as shown in the previous two types but it fills the colour to the entire radar. Given below is the example for this type of chart.
How to Understand the Radar Chart?
Like in the column chart in the spider chart in excel, also we have X & Y axis. The x-axis is nothing but each end of the spider and each step of the spider considered as Y-axis. In the below-given image circles which are marked in orange are X-axis and circles which are marked in blue are Y-axis. Zero point of the radar chart in excel starts from the centre of the wheel. Towards the edge of the spike, a point reaches, the higher the value.
How to Create Radar Chart in Excel?
Radar Chart in Excel is very simple and easy to use. Let understand the working of with some Radar Chart examples.
Radar Chart Example #1 – Sales Analysis in 4 different quarters
Step 1: Create Data in the below format. Below data shows quarterly sales performance over a period of 10 years. So now, let us present this in a spider chart.
Step 2: Go to Insert tab in excel > Other Charts > Select Radar with Marker chart. This will insert a blank Radar Chart in Excel.
Step 3: Right click on the chart and select below.
Click on Add button
Select Series name as Q-1 and Series value as values click ok.
Again repeat this procedure for all the quarters and after that, your screen should look like this.
After this click on OK and chart will be inserted and below is the illustration of how the radar chart in excel looks before formatting.
Step 4: Format the Chart as per our wish.
Right click on each line and change the line colour, change the marker style option as per your needs. Add chart title to tell the user what it is. And finally, your and chart will look like this.
Interpretation of the data:
- By looking at the outset of the spider we can clearly find out in 2012 Q1 revenue was the highest among all the 10 years revenue. And in 2011 Q1 revenue was the lowest.
- In Q2 the highest revenue was in 2011 and the lowest point is the year 2014.
- In Q3 the highest revenue was in 2009 and the lowest revenue was in 2010.
- In Q4 the highest revenue was in 2011 and the lowest revenue occurred year is 2012
- In none of the year, there is a consistent growth of the revenue over 4 quarters. There is always a volatility in revenue generation across quarters.
Additionally, You can remove the lines of the chart but highlight only the markers. Advanced formatting is always a treat to watch.
- Select each line and press Ctrl + 1 > Line Colour > Select no line.
- Select marker options > select built-in > choose the colour as per your wish.
- Repeat this for all the lines. Make sure you select different marker colours but the same markers.
- Click on spider lines and press Ctrl + 1 > Line Colour > Solid Line > Select the colour.
- Select line style > Dash Type > Select dotted lines.
- Select background colour from format tab.
- So your chart looks beautifully like the below one.
Radar Chart Example #2 – Target vs Customer Satisfaction Level
Step 1: Create the data in a below format and apply chart type 1 (ref types of chart).
Step 2: Select the data to apply chart type 1. Insert > Other Charts > Select Radar Chart.
Initially, your chart looks like the below one.
Step 3: Do the formatting as per your ideas (to do formatting refer last example and play with it).
- Change target line colour to red achieved line colour to green.
- Change spider line colour to light blue and change the line style to dotted lines.
- Change X-axis values to word art styles.
- Insert header for the chart and format it nicely.
After all the formatting your chart should look like the below chart.
Step 4: Get rid of the legends and use manual legends to adjust the chart neatly. To insert manually go to insert tab and insert Shapes.
Before removing and inserting manual legends.
After removing and inserting manual legends.
Interpretation of the Spider Chart in Excel
- Red line shows the target level each category and similarly, green line indicates the achieved level of each category.
- Politeness category achieved the 100% score by reaching 9 out of 9.
- Next, closest categories are responsiveness & skill set by scoring 8 out of 9.
- The least anchored category is urgency level it achieved only 2 out of 9.
- There is conclusive evidence that customer care executives need to works on the urgency level and need to gain more knowledge on the product.
- Maybe they require a training to know more about the product.
- They need to create the urgency level in order to close more deals often.
Advantages of using Spider chart in Excel
- When you are presenting two-dimensional data set it is very useful to tell the story of the data set just by creating the radar chart in Excel.
- The radar chart in excel is more suitable when the exact values aren’t critical for a reader but the overall chart tells some story.
- Each category can be easily compared each along with their own axis and overall differences are apparent by the size of each radar.
- Spider charts in excel are more effective when you are comparing target vs achieved performance.
Disadvantages of using Spider chart in Excel
- The comparison of observations on a radar chart in excel could be confusing once there are more than a couple webs on the chart.
- When there are too many variables, it creates too many axes, the crowd is too much.
- Though there are multiple axes that have gridlines connecting them for reference, issues arise when you try to compare values across different axes.
Things to consider while creating a radar chart in excel to visualise your report.
- Make sure you are not using more than two variables, Otherwise it will be a very tedious task for a user to understand and come to a conclusion.
- Try to cover the background with light colours to tell the story colourfully.
- Use different line styles to attract users attention.
- Arrange the data schematically.
- Enlarge the spider web to give clear visualisation
- Work on axis values to avoid too many intervening axis values.
- Get rid of legends to enlarge the spider web, but insert the legends by adding shapes.
- To make the chart easier to read one of the simplest things to alter is the size of the text. Do all these in the formatting section.
You can download this Radar Chart in Excel template here – Radar Chart Excel Template
This has been a guide to Radar Chart in Excel. Here we discuss its uses and how to create Spider Chart in Excel along with excel example and downloadable excel templates. You may also look at these useful functions in excel –