Documents for Excel .NET Edition | GCDocuments
Features / Chart / Chart Types / Radar Chart
In This Topic
    Radar Chart
    In This Topic

    A Radar chart is used to display circular visual representation of a 2-dimensional data. One can think of it as a circular XY chart. These charts represent each variable on a separate axis, which are arranged radially at equal distances from each other. Each of these axes share the same tick marks and scale. The data for each observation is plotted along these axis and then joined to form a polygon. Radar charts are generally used for analyzing performance or comparing values such as revenue and expense.

    GcExcel supports the following types of radar charts.

    Chart Type Chart Snapshot Use Case
    Radar chart

    Radar chart

    Radar chart type can be used to represent multivariate data plotted in rows and columns in the graphical format.
    RadarFilled chart

    RadarFilled chart

    RadarFilled chart type can be used to display radar chart with areas highlighted by different colored regions for each value.
    RadarMarkers chart

    RadarMarkers chart

    RadarMarkers chart can be used to display radar chart with markers representing data for each value along with areas highlighted by different line colors.

    Using Code

    Refer to the following code to add RadarMarkers chart:

    Copy Code
      public void RadarCharts()
          // Initialize workbook
          Workbook workbook = new Workbook();
          // Fetch default worksheet 
          IWorksheet worksheet = workbook.Worksheets[0];
          // Prepare data for chart
          worksheet.Range["A1:D7"].Value = new object[,]
         {null, "Lisa", "Tim", "Jim"},
         {"Mathematics", 87, 64, 79},
         {"English", 79, 58, 78},
         {"History", 62, 70, 82},
          {"Biology", 85, 63, 54},
          {"Geography", 64, 85, 75},
          {"Zoology", 62, 79, 94}
          // Add Radar Chart
          IShape radarChartShape = worksheet.Shapes.AddChart(ChartType.RadarMarkers, 250, 20, 360, 230);
          // Adding series to SeriesCollection
          radarChartShape.Chart.SeriesCollection.Add(worksheet.Range["A1:D7"], RowCol.Columns, true, true);
          // Configure Chart Title 
          radarChartShape.Chart.ChartTitle.TextFrame.TextRange.Paragraphs.Add("Test Score Analysis");
          // Saving workbook to Xlsx
          workbook.Save(@"27-RadarChart.xlsx", SaveFileFormat.Xlsx);