Document Solutions for Excel, .NET Edition | Document Solutions
Features / Chart / Chart Types / Surface Chart
In This Topic
    Surface Chart
    In This Topic

    Surface charts are useful when you want to find the optimum combinations between two data sets. As in a topographic map, the colors and patterns indicate the areas that are in the same range of values. A surface chart plots data on a three-dimensional surface, in a similar way that topographic maps plots elevation. The colors and patterns represent values within the same range. This chart type is especially useful for finding the optimum results when comparing two or more sets of data.

    DsExcel supports the following types of Surface charts.

    Chart Type Chart Snapshot Purpose
    Surface chart

    Surface chart

    Surface chart is a chart with a 3-D visual effect.
    SurfaceTopView chart

    SurfaceTopView chart

    SurfaceTopView chart depicts surface chart viewed from above.
    SurfaceTopViewWireframe chart

    SurfaceTopViewWireframe chart

    SurfaceTopViewWireframe chart depicts surface chart viewed from above with no fill color.
    SurfaceWireframe chart

    SurfaceWireframe chart

    SurfaceWireframe chart depicts surface chart with a 3-D visual effect and no fill color.

    Using Code

    Refer to the following code to add SurfaceWireframe chart.

    Copy Code
      public void SurfaceCharts()
          // Initialize workbook
          Workbook workbook = new Workbook();
          // Fetch default worksheet 
          IWorksheet worksheet = workbook.Worksheets[0];
          // Prepare data for chart
          worksheet.Range["A1:D4"].Value = new object[,]
         {null, "Q1", "Q2", "Q3"},
         {"Mobile Phones", 1330, 2345, 3493},
         {"Laptops", 2032, 3632, 2197},
         {"Tablets", 6233, 3270, 2030}
          // Add Surface Chart
          IShape surfaceChartShape = worksheet.Shapes.AddChart(ChartType.SurfaceWireframe, 250, 20, 360, 230);
          // Adding series to SeriesCollection
          surfaceChartShape.Chart.SeriesCollection.Add(worksheet.Range["A1:D4"], RowCol.Columns, true, true);
          // Configure Chart Title 
          surfaceChartShape.Chart.ChartTitle.TextFrame.TextRange.Paragraphs.Add("Annual Sales Record");
          // Saving workbook to Xlsx
          workbook.Save(@"25-SurfaceChart.xlsx", SaveFileFormat.Xlsx);