{"id":5855,"date":"2020-07-16T08:08:03","date_gmt":"2020-07-16T06:08:03","guid":{"rendered":"https:\/\/www.myexcelonline.com\/?p=5855"},"modified":"2024-03-23T21:31:51","modified_gmt":"2024-03-23T20:31:51","slug":"create-a-radar-chart-for-performance-reviews","status":"publish","type":"post","link":"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-a-radar-chart-for-performance-reviews\/","title":{"rendered":"Create an Excel Radar Chart For Performance Reviews"},"content":{"rendered":"<p><strong>Excel Radar Charts<\/strong> can be used to <strong>compare multiple variables<\/strong> to a central point and show the difference between sub-groups.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/radar-chart\/\" target=\"_blank\" rel=\"noopener\">Radar Chart in Excel<\/a> is very handy to show a rating on several performance areas.<\/p>\n<p>It is useful when analyzing results from a <strong>survey<\/strong>, <strong>compare target vs actual values<\/strong>, <strong>performance review<\/strong>, etc.<\/p>\n<p>In this article, you will be provided with a detailed guide on:<\/p>\n<ul>\n<li><strong><a href=\"#what-is-an-excel-radar-chart\">What is an Excel Radar Chart?<\/a><\/strong><\/li>\n<li><strong><a href=\"#types-of-excel-radar-charts\">Types of Excel Radar Charts<\/a><\/strong><\/li>\n<li><strong><a href=\"#examples-of-excel-radar-charts\">Examples of Excel Radar Charts<\/a><\/strong><\/li>\n<li><strong><a href=\"#advantages-and-disadvantages-of-radar-charts\">Advantages and Disadvantages of Radar Charts<\/a><\/strong><\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3><a id=\"what-is-an-excel-radar-chart\"><\/a>What is an Excel Radar Chart?<\/h3>\n<p>Excel Radar Charts are used to show a multi-variate comparison in a 2-dimensional form.<\/p>\n<p>It is a <strong>graphical representation of data<\/strong> that can be used to display a lot of information into a single image.<\/p>\n<p>It is sometimes called a <strong>spider<\/strong> or <strong>star<\/strong> chart. Each spike in the chart represents a data and the length of the spike is the magnitude of that data point.<\/p>\n<p>A Radar Chart has <strong>three main sections<\/strong> in it: Plot Area, Chart Title, and Legend. A Plot Area<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-286.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18576\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-286.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"475\" height=\"380\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-286.png 475w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-286-300x240.png 300w\" sizes=\"(max-width: 475px) 100vw, 475px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"types-of-excel-radar-charts\"><\/a>Types of Excel Radar Charts<\/strong><\/h3>\n<p>Radar Charts are of 3 types &#8211; Radar, Radar with markers, and Filled Radar.<\/p>\n<ul>\n<li><strong>Radar Chart<\/strong> &#8211; This is a basic radar chart and it displays values that are relative to the central point.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/290d9e1377cf3817b503afc6d8344eae.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18579\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/290d9e1377cf3817b503afc6d8344eae.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"476\" height=\"383\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/290d9e1377cf3817b503afc6d8344eae.png 476w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/290d9e1377cf3817b503afc6d8344eae-300x241.png 300w\" sizes=\"(max-width: 476px) 100vw, 476px\" \/><\/a><\/p>\n<ul>\n<li><strong>Radar with Markers &#8211;<\/strong> This is a Radar Chart that displays markers on the data points.<br \/>\n<a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/51b910be76e46e870a57cd50592720ea.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18575\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/51b910be76e46e870a57cd50592720ea.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"480\" height=\"386\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/51b910be76e46e870a57cd50592720ea.png 480w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/51b910be76e46e870a57cd50592720ea-300x241.png 300w\" sizes=\"(max-width: 480px) 100vw, 480px\" \/><\/a><\/li>\n<li><strong>Filled Chart<\/strong> &#8211; In this Radar Chart, the entire radar is filled with a color.<\/li>\n<\/ul>\n<p style=\"padding-left: 40px\"><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/7b0e747f15323f907e30a9cd68fb1fbb.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18581\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/7b0e747f15323f907e30a9cd68fb1fbb.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"479\" height=\"387\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/7b0e747f15323f907e30a9cd68fb1fbb.png 479w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/7b0e747f15323f907e30a9cd68fb1fbb-300x242.png 300w\" sizes=\"(max-width: 479px) 100vw, 479px\" \/><\/a><\/p>\n<p>Let&#8217;s look at the detailed tutorial on How to create a <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/pie-chart-in-excel\/\" target=\"_blank\" rel=\"noopener\">Radar Chart in Excel<\/a>!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"examples-of-excel-radar-charts\"><\/a>Examples of Excel Radar Charts<\/strong><\/h3>\n<p><span style=\"color: #ff0000\"><strong>Example 1: Performance Chart<\/strong><\/span><\/p>\n<p>When I had to give out performance reviews, it was a very helpful snapshot for me to show to my colleagues how their performance was compared to last year!<\/p>\n<p>Here is an example of a table with several ratings:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-01.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-5857\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-01.jpg\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"281\" height=\"164\" \/><\/a><\/p>\n<p>In this example, I show you how easy it is to insert a Radar Chart using Excel.<\/p>\n<p>&nbsp;<\/p>\n<div class=\"after-post-box\">\n<p><iframe src=\"https:\/\/www.youtube.com\/embed\/-2w6YGd_M74?rel=0 \" width=\"800\" height=\"400\" frameborder=\"0\" allowfullscreen=\"allowfullscreen\"><span data-mce-type=\"bookmark\" style=\"width: 0px;overflow: hidden;line-height: 0\" class=\"mce_SELRES_start\">\ufeff<\/span><\/iframe><a href=\"https:\/\/www.youtube.com\/c\/MyExcelOnlinecomtutorials?sub_confirmation=1\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" class=\"alignmiddle wp-image-111468 size-full\" style=\"vertical-align: middle\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2019\/04\/1.yt_.png\" alt=\"\" title=\"\"><\/a><\/p>\n<\/div>\n<p>Follow the step-by-step tutorial on how to create Excel Radar Charts and make sure to download the Excel Workbook to follow along:<\/p>\n<div class=\"after-post-box\">\n<p class=\"line-two\" style=\"text-align: center\"><strong><a class=\"IRPP_minimalist icon-download button small\" href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Radar-Chart.xlsx\" target=\"_blank\" rel=\"noopener noreferrer\" data-leadbox=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart.xlsx\" data-leadbox-id=\"147284833f72a2:12f08263ab46dc\"><span class=\"ctaText px-3 text-capitalize\">Download excel workbook<i class=\"fa fa-download\"><\/i><\/span><span class=\"postTitle px-3\">Radar-Chart.xlsx<\/span><\/a><\/strong><\/p>\n<\/div>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong> <\/span>Highlight your table\u00a0and go to:<\/p>\n<p><em><strong>Insert &gt; Recommended Charts (Excel 2013 &amp; above)<\/strong><\/em><\/p>\n<p><em><strong>Insert &gt; Other Charts (Excel 2007 &amp; 2010)<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-02.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-5858\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-02.jpg\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"260\" height=\"169\" \/><\/a><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-03.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-5859\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-03.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"451\" height=\"134\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-03.png 451w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-03-300x89.png 300w\" sizes=\"(max-width: 451px) 100vw, 451px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select <em><strong>All Charts &gt; Radar &gt; Radar with Markers &gt; OK<\/strong><\/em><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-04.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-5860\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-04.jpg\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"634\" height=\"600\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-04.jpg 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-04-300x284.jpg 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span>\u00a0Now you have your<strong>\u00a0Radar Chart<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-05.jpg\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone wp-image-5861 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-05.jpg\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"541\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-05.jpg 541w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/Radar-Chart-05-300x166.jpg 300w\" sizes=\"(max-width: 541px) 100vw, 541px\" \/><\/a><\/p>\n<p>Now you can use your radar chart to convince your own boss that your performance has skyrocketed this year!<\/p>\n<p>You can even change the shape and size of the marker displayed on the line. To do that, follow the steps below:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Select the line and Press <strong>Ctrl +1<\/strong> to open the <strong>Format Series<\/strong> dialog box.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-302.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18632\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-302.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"473\" height=\"358\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-302.png 473w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-302-300x227.png 300w\" sizes=\"(max-width: 473px) 100vw, 473px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Select<strong> Fill<\/strong> Icon and then Select <strong>Marker<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-301.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18633\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-301.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"279\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-301.png 279w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-301-165x300.png 165w\" sizes=\"(max-width: 279px) 100vw, 279px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3:<\/strong><\/span> Under <strong>Built-in <\/strong>option, select type and size that you want.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-304-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18635\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-304-1.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"283\" height=\"507\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-304-1.png 283w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-304-1-167x300.png 167w\" sizes=\"(max-width: 283px) 100vw, 283px\" \/><\/a><\/p>\n<p>Let&#8217;s try to use this chart with another example!<\/p>\n<p><span style=\"color: #ff0000\"><strong>Example 2: Competitive Analysis<\/strong><\/span><\/p>\n<p>A survey was conducted regarding the comparison of 3 different Mobile Phone Brands and the results were combined in the data table.<\/p>\n<p>In the table below, you have a <strong>survey data<\/strong> that compares 3 mobile company brands based on various categories.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/cc0b34bb4058e7ccd9068678f543afb4.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18585\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/cc0b34bb4058e7ccd9068678f543afb4.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"512\" height=\"268\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/cc0b34bb4058e7ccd9068678f543afb4.png 512w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/cc0b34bb4058e7ccd9068678f543afb4-300x157.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/a><\/p>\n<p>Looking at this data in one glance, it will be difficult to judge which brand is preferred by the customers. So, let&#8217;s create an Excel <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/grouped-bar-charts-in-excel\/\" target=\"_blank\" rel=\"noopener\">Radar Chart<\/a> using this data.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1:<\/strong><\/span> Select the <strong>table<\/strong> containing the data.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-287.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18591\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-287.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"557\" height=\"404\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-287.png 557w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-287-300x218.png 300w\" sizes=\"(max-width: 557px) 100vw, 557px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2:<\/strong><\/span> Go to <strong>Insert<\/strong> &gt; <strong>Waterfall, Funnel, Stock, Surface or Radar Chart<\/strong> &gt; <strong>Radar Chart<\/strong> (In Excel 2019)<\/p>\n<p>Go to<strong> Insert &gt; Stock, Surface or Radar Chart<\/strong> &gt; <strong>Radar Chart<\/strong> (In Excel 2013)<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18592\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"1053\" height=\"605\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288.png 1053w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288-300x172.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288-1024x588.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-288-768x441.png 768w\" sizes=\"(max-width: 1053px) 100vw, 1053px\" \/><\/a><\/p>\n<p>Your Excel Radar Chart will be ready.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-289.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18593\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-289.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"530\" height=\"317\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-289.png 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-289-300x179.png 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n<p>To change the type to Radar with markers or filled Radar Chart:<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Select the existing chart<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-290.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18587\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-290.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"592\" height=\"347\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-290.png 592w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-290-300x176.png 300w\" sizes=\"(max-width: 592px) 100vw, 592px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Go to <strong>Chart Design<\/strong> &gt; <strong>Change Chart Type<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18588\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"1182\" height=\"126\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291.png 1182w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291-300x32.png 300w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291-1024x109.png 1024w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-291-768x82.png 768w\" sizes=\"(max-width: 1182px) 100vw, 1182px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>In the <strong>Change Chart Type<\/strong> dialog box, select the desired chart you want to change to and then Press <strong>OK<\/strong>.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-295.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18589\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-295.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"633\" height=\"603\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-295.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-295-300x286.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/a><\/p>\n<p>If you select Filled Radar Chart, this is how your chart will look like.<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-294.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18590\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-294.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"528\" height=\"317\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-294.png 528w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/03\/Screenshot-294-300x180.png 300w\" sizes=\"(max-width: 528px) 100vw, 528px\" \/><\/a><\/p>\n<p>From the chart, you can easily infer that based on the survey result, Brand B is preferred over the other two.<\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #ff0000\"><strong>Example 3: Sales Analysis<\/strong><\/span><\/p>\n<p>The below data shows weekly sales performance (in $ &#8216;000) of various products sold in\u00a0a supermarket:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-296.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18618\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-296.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"546\" height=\"254\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-296.png 546w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-296-300x140.png 300w\" sizes=\"(max-width: 546px) 100vw, 546px\" \/><\/a><\/p>\n<p>You can use this data to <a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/blog\/create-excel-harvey-balls\/\" target=\"_blank\" rel=\"noopener\">create a Radar Chart<\/a> in Excel.<\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 1: <\/strong><\/span>Select the <strong>Data Table<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-297.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18627\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-297.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"634\" height=\"377\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-297.png 634w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-297-300x178.png 300w\" sizes=\"(max-width: 634px) 100vw, 634px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 2: <\/strong><\/span>Go to <strong>Insert<\/strong> &gt;<strong> Recommended Chart (Excel 2013 &amp; Above)<\/strong><\/p>\n<p><strong>Insert &gt; Other Charts (Excel 2007 &amp; 2010)<\/strong><\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-299-1.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18629\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-299-1.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"593\" height=\"125\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-299-1.png 593w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-299-1-300x63.png 300w\" sizes=\"(max-width: 593px) 100vw, 593px\" \/><\/a><\/p>\n<p><span style=\"color: #ff0000\"><strong>STEP 3: <\/strong><\/span>In the <strong>Insert Chart\u00a0<\/strong>dialog box, Go to <strong>All Charts<\/strong> &gt; <strong>Radar Charts\u00a0<\/strong>and then Press <strong>OK<\/strong>.<\/p>\n<p><span style=\"color: #ff0000\"><strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-298.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18630\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-298.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"633\" height=\"602\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-298.png 633w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-298-300x285.png 300w\" sizes=\"(max-width: 633px) 100vw, 633px\" \/><\/a><\/strong><\/span><\/p>\n<p>This is how your Sales Analysis Excel Radar Chart will look like:<\/p>\n<p><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-300.png\" target=\"_blank\"><img loading=\"lazy\" decoding=\"async\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone size-full wp-image-18631\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-300.png\" alt=\"Create an Excel Radar Chart For Performance Reviews\" width=\"512\" height=\"343\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-300.png 512w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2020\/07\/Screenshot-300-300x201.png 300w\" sizes=\"(max-width: 512px) 100vw, 512px\" \/><\/a><\/p>\n<p>In the Radar Chart, the weekly sales figure for various products are shown with the <strong>axes varying from 0 to 600<\/strong>.<\/p>\n<p>Sales for each product are easily <strong>comparable on their own axis<\/strong> and the overall difference is visible based on the size and shape of the polygon formed.<\/p>\n<p>Let&#8217;s discuss in detail the merits and limitations of using a Radar Chart!<\/p>\n<p>&nbsp;<\/p>\n<h3><strong><a id=\"advantages-and-disadvantages-of-radar-charts\"><\/a>Advantages and Disadvantages of Excel Radar Charts<\/strong><\/h3>\n<p><span style=\"color: #ff0000\"><strong>Advantages:<\/strong><\/span><\/p>\n<ul>\n<li>It is useful to show a lot of information in a single image.<\/li>\n<li>It is more useful when you want to know the overall picture, not an exact value.<\/li>\n<li>It is useful when values or categories are not directly comparable.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<p><strong><span style=\"color: #ff0000\">Limitations:<\/span><\/strong><\/p>\n<ul>\n<li>The more the number of webs in the chart, <span data-story-id=\"story_94b6a6cf62bcfefeeda4741793f1ce4d\" data-room-id=\"room_d62db1d106bc54e2ee4e1d1ed91d580e\" data-timestamp=\"1595230254327\" data-text=\"the more complicated it gets and harder to analyze\" data-userid=\"1245285956862005248\" data-orgid=\"425304450073260032\">the more complicated it gets and harder to analyze<\/span>.<\/li>\n<li>Too much data makes the chart crowded and harder to interpret.<\/li>\n<li>It is not ideal for making a trade-off decision.<\/li>\n<\/ul>\n<p>&nbsp;<\/p>\n<h3>Conclusion<\/h3>\n<p>In this article, you have learned in-depth about the Radar Chart Excel, its types, steps to create a chart in excel, and its advantages and disadvantages.<\/p>\n<p><em>Excel provides a plethora of charts to choose the right one for your data. To take a look at them, <strong><a href=\"https:\/\/www.myexcelonline.com\/meo-staging\/excel-charts\/how-to-make-a-graph-in-excel\/\" target=\"_blank\">click here<\/a><\/strong>.<\/em><\/p>\n<p>&nbsp;<\/p>\n<p><span style=\"color: #0000ff\"><strong>HELPFUL RESOURCE:<\/strong><\/span><\/p>\n<p><a href=\"https:\/\/members.excelcampus.com\/a\/3427\/6AmL34sQ\" target=\"_blank\" rel=\"noopener noreferrer nofollow\"><img loading=\"lazy\" decoding=\"async\" alt=\"Create an Excel Radar Chart For Performance Reviews\" title=\"Create an Excel Radar Chart For Performance Reviews\" class=\"alignnone wp-image-6011 size-full\" src=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/530x300-2.jpg\" width=\"530\" height=\"300\" srcset=\"https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/530x300-2.jpg 530w, https:\/\/www.myexcelonline.com\/meo-staging\/wp-content\/uploads\/2017\/02\/530x300-2-300x170.jpg 300w\" sizes=\"(max-width: 530px) 100vw, 530px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel Radar Charts can be used to compare multiple variables to a central point and show the difference between sub-groups. Radar Chart in Excel is very handy to show a rating on several performance areas. It is useful when analyzing results from a survey, compare target vs actual values, performance review, etc. In this article, [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":17298,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"cos_headline_score":0,"cos_seo_score":0,"cos_headline_text":"Create an Excel Radar Chart For Performance Reviews","cos_headline_has_been_analyzed":false,"cos_last_analyzed_headline":[],"om_disable_all_campaigns":false},"categories":[5,29],"tags":[160,673,226],"acf":[],"_links":{"self":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5855"}],"collection":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/comments?post=5855"}],"version-history":[{"count":0,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/posts\/5855\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media\/17298"}],"wp:attachment":[{"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/media?parent=5855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/categories?post=5855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.myexcelonline.com\/meo-staging\/wp-json\/wp\/v2\/tags?post=5855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}