Radar Charts with Excel

Radar Charts with Excel

In this part of this series, we will learn about the Radar Chart, how to create and its use. Besides, we will practice together to create a Radar Chart in Excel with Excel Office Component.

Definition

  • Radar Charts - short version
  • A Radar Chart is a graphical display of the difference between the actual and ideal performance. It is useful to identify performance and identify strengths and weaknesses.
  • Radar Charts - extended version
  • A Radar Chart is a graphical method that displays multivariate data in the form of a two-dimensional chart of three or more representative numbers on the axis starting from one single point. The angle of the axes and the relative position are often uninformative. The Radar Chart is also known as a web chart, spider chart, star chart, star plot, spider web chart, irregular polygons, or polar chart.
  • The Radar Chart is a chart or plot that consists of a series of angular Equi-spokes, called radii, with each said representing one of the variables. The data length of a given is proportional to the size of the variable for the data points relative to the maximum level of the variable on all data points. We will need to draw a line to connect the data values.
  • In Short: Radar Chart is a chart that used to compare the set values ​​of a data area. Thereby showing the change of before and after the operation process.

More about Radar Chart

  • Note: Radar Chart is also known as Spider Web Chart. Because the chart clearly shows the criteria, a Spiderweb or a Radar Chart can easily be made into a poster to share information with others in the organization in a simple way and to plan further.

What is a spider web chart?

  • A Spider Web Chart is a graph that allows you to evaluate the performance of several goals, using multiple criteria.
  • Each axis of the Spider Web Chart represents one criterion. We can use this chart during benchmarking to show:
  • Current performance
  • The purpose or the immediate goal
  • What might be industry standards
  • An international standard

NOTE: You should use different colors for the axes to enhance the transmission capacity of the Spider Web Chart.

Why is Spider Web Chart useful?

Spider Web Chart will allow comparing the achieved values ​​with the average of the industry, thereby showing the strengths and weaknesses of the business.

How will spider web diagram help you?

  • Spider Web Chart gives you greater control over the performance of all different resources. Spider Web Chart is also an easy-to-use chart; just follow these steps:
  • Step 1: Select and define criteria; you can accept about 5 to 10 types of standards. You can use Brainstorming or an Affinity Diagram to determine the appropriate measures.
  • Step 2: Draw a circle with spokes; each spoke are corresponding to a criterion. The center of the ring is numbered 0 - that is, we haven't done anything yet (the effect is zero), the outer end of the spokes is the max - we have achieved the highest efficiency. We can classify the performance by subjective or objective.
  • Step 3: Classify all performance criteria. If it is a subjective assessment, each member of the group or even the whole group can do it with the agreement of everyone.
  • Step 4: If the given criteria have data showing the objectivity, we can record them on the chart.
  • Step 5: Connect the data and colorize the area within the connection points. We may use different colors when displaying data from individuals, or use only one color but with a larger dot.
  • Step 6: Discuss the results to make sure your chart is clear and consistent.
  • Data connection and coloring clarify the area within the connection points. We can use different colors when displaying data from individuals or discuss only one color with larger dots. Discuss the results to make sure your chart is clear. And consistent.

Where can you apply Spider Web Charts?

  • You may want to use a Spider Web Chart whenever the improvement team wants to understand its current implementation progress, and where should the priority be for further implementation.

When is spider web diagram useful?

  • A Spider Web Chart is useful when the improvement team wants to understand how to take priority to improve performance in the areas/areas affecting the project. We can also use it as a report of progress on improvement.

How does the spider web diagram benefit?

  • A Spider Web Chart will directly help the entire workgroup through the self-assessment process. It also helps the manager to see how the team has made progress. What you see in the Spider Web Chart will help your senior leader and everyone know about the team's progress.

Create a Radar Chart in Excel with Excel Office Component

  • So we have a rough look at the features and uses of the Radar Chart with Excel. Perhaps now you will want to create a Radar Chart for yourself. However, creating a Radar Chart with Excel on the .NET platform will have a lot of difficulties when it is necessary to use a lot of different knowledge and tools.
  • No need to worry anymore cause you now have the full support of the Excel Office Component, making it easier than ever to create charts with Excel.
  • We will show you how to create yourself an Excel Radar Chart step-by-step, so please stick with us ;)
  • First, please create your own Dataset, which is an original Excel file, and we will proceed to draw a Radar chart based on this amount of data. To do this with the .NET platform, just follow these simple steps:
  • C# Version:
        sheet.Range["B3"].Text = "Precipitation,in.";
        sheet.Range["C3"].Text = "Temperature,deg.F";

        sheet.Range["A4"].Text = "Jan";
        sheet.Range["A5"].Text = "Feb";
        sheet.Range["A6"].Text = "March";
        sheet.Range["A7"].Text = "Apr";
        sheet.Range["A8"].Text = "May";
        sheet.Range["A9"].Text = "June";
        sheet.Range["A10"].Text = "July";
        sheet.Range["A11"].Text = "Aug";
        sheet.Range["A12"].Text = "Sept";
        sheet.Range["A13"].Text = "Oct";
        sheet.Range["A14"].Text = "Nov";
        sheet.Range["A15"].Text = "Dec";

        sheet.Range["B4"].Number = 10.9;
        sheet.Range["B5"].Number = 8.9;
        sheet.Range["B6"].Number = 8.6;
        sheet.Range["B7"].Number = 4.8;
        sheet.Range["B8"].Number = 3.2;
        sheet.Range["B9"].Number = 1.4;
        sheet.Range["B10"].Number = 0.6;
        sheet.Range["B11"].Number = 0.7;
        sheet.Range["B12"].Number = 1.7;
        sheet.Range["B13"].Number = 5.4;
        sheet.Range["B14"].Number = 9.0;
        sheet.Range["B15"].Number = 10.4;

        sheet.Range["C4"].Number = 47.5;
        sheet.Range["C5"].Number = 48.7;
        sheet.Range["C6"].Number = 48.9;
        sheet.Range["C7"].Number = 50.2;
        sheet.Range["C8"].Number = 53.1;
        sheet.Range["C9"].Number = 56.3;
        sheet.Range["C10"].Number = 58.1;
        sheet.Range["C11"].Number = 59.0;
        sheet.Range["C12"].Number = 58.5;
        sheet.Range["C13"].Number = 55.4;
        sheet.Range["C14"].Number = 51.1;
        sheet.Range["C15"].Number = 47.8;
        sheet.UsedRange.AutofitColumns();
        
  • VB Version:
        sheet.Range("B3").Text = "Precipitation,in."
        sheet.Range("C3").Text = "Temperature,deg.F"

        sheet.Range("A4").Text = "Jan"
        sheet.Range("A5").Text = "Feb"
        sheet.Range("A6").Text = "March"
        sheet.Range("A7").Text = "Apr"
        sheet.Range("A8").Text = "May"
        sheet.Range("A9").Text = "June"
        sheet.Range("A10").Text = "July"
        sheet.Range("A11").Text = "Aug"
        sheet.Range("A12").Text = "Sept"
        sheet.Range("A13").Text = "Oct"
        sheet.Range("A14").Text = "Nov"
        sheet.Range("A15").Text = "Dec"

        sheet.Range("B4").Number = 10.9
        sheet.Range("B5").Number = 8.9
        sheet.Range("B6").Number = 8.6
        sheet.Range("B7").Number = 4.8
        sheet.Range("B8").Number = 3.2
        sheet.Range("B9").Number = 1.4
        sheet.Range("B10").Number = 0.6
        sheet.Range("B11").Number = 0.7
        sheet.Range("B12").Number = 1.7
        sheet.Range("B13").Number = 5.4
        sheet.Range("B14").Number = 9.0
        sheet.Range("B15").Number = 10.4

        sheet.Range("C4").Number = 47.5
        sheet.Range("C5").Number = 48.7
        sheet.Range("C6").Number = 48.9
        sheet.Range("C7").Number = 50.2
        sheet.Range("C8").Number = 53.1
        sheet.Range("C9").Number = 56.3
        sheet.Range("C10").Number = 58.1
        sheet.Range("C11").Number = 59.0
        sheet.Range("C12").Number = 58.5
        sheet.Range("C13").Number = 55.4
        sheet.Range("C14").Number = 51.1
        sheet.Range("C15").Number = 47.8
        sheet.UsedRange.AutofitColumns()
  • To create a new Excel file for storing output data - that is, a Radar Chart, you can use the WorkbookManager class in our Excel Office Component library.
  • C# Version: WorkbookManager manager = new WorkbookManager();
  • VB Version: Dim manager As New WorkbookManager()
  • Once you've created a WorkbookManager, you can add new workbooks as well as specify the version of the newly created workbook.
  • Add a new workbook
  • C# Version: Workbook workbook = manager.Workbooks.Add();
  • VB Version: Dim workbook As Workbook = manager.Workbooks.Add()
  • Declare a new version
  • C# Version: workbook.Version = SaveAsFormat;
  • VB Version: workbook.Version = SaveAsFormat
  • You can then create yourself a new sheet:
  • C# Version: IWorksheet sheet = workbook.Worksheets[0];
  • VB Version:
  • After this step, everything is ready; you can now create your chart with the necessary attributes.
  • Add a new Chart
  • C# Version: IChart chart = workbook.Charts.Add();
  • VB Version: Dim sheet As IWorksheet = workbook.Worksheets(0)
  • Declare properties
  • C# Version:
        IChart chart = workbook.Charts.Add();
        chart.Name = "Radar Chart";
        chart.ChartTitle = "Radar Chart - Sales by Region";

        chart.DataRange = sheet.Range["A3:C15"];
  • VB Version:
        Dim chart As IChart = workbook.Charts.Add()
        chart.Name = "Radar Chart"
        chart.ChartTitle = "Radar Chart - Sales by Region"

        chart.DataRange = sheet.Range("A3:C15")
  • Select chart category and location:
  • C# Version:
        switch (Type)
        {
            case 0:
                chart.ChartType = ChartType.Radar;
                break;

            case 1:
                chart.ChartType = ChartType.Radar_Filled;
                break;

            case 2:
                chart.ChartType = ChartType.Radar_Markers;
                break;
        }

        chart.IsSeriesInRows = true;
        chart.Legend.Position = ExcelLegendPosition.Bottom;
        chart.Legend.IsVerticalLegend = false;
  • VB Version:
      Select Case Type
            Case 0
                chart.ChartType = ChartType.Radar

            Case 1
                chart.ChartType = ChartType.Radar_Filled

            Case 2
                chart.ChartType = ChartType.Radar_Markers
        End Select

        chart.IsSeriesInRows = True
        chart.Legend.Position = ExcelLegendPosition.Bottom
        chart.Legend.IsVerticalLegend = False
  • And with the Activate() command, your Radar Chart creation is complete.
  • C# Version: chart.Activate();
  • VB Version: chart.Activate()

The full source code of this example is also available in our Excel package.

A live demo for Radar Charts is also available on our site. If you also need Excel functionality, check out our Excel online demos.

45-Day Money Back Guarantee

We will refund your full money in 45 days
if you are not satisfied with our products

Buy Now
You have successfully subcribed to our mailing list.
Dont miss out Get update on new articles and other opportunities Subscribe