Spread WPF 17
Spread WPF Documentation / Developer's Guide / Working with Charts / Creating Charts / Creating Chart Types / Adding a Surface Chart
In This Topic
    Adding a Surface Chart
    In This Topic

    You can create different types of surface charts such as Surface, SurfaceContour, SurfaceWireFrameContour, and SurfaceWireFrame.

    An example of scatter chart

    Using Code

    The following code creates a surface chart.

    1. Create values with the SpreadDataSeries class.
    2. Use the SpreadSurfaceChart class to create a chart and set the type.
    3. Add the series.
    4. Add the chart to the sheet.
    CS
    Copy Code
    GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries ds1 = new GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries();
    ds1.Values = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
    ds1.Values.Add(2);
    ds1.Values.Add(3);
    ds1.Values.Add(5);
    GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries ds2 = new GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries();
    ds2.Values = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
    ds2.Values.Add(3);
    ds2.Values.Add(6);
    ds2.Values.Add(4);
    GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries ds3 = new GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries();
    ds3.Values = new GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection();
    ds3.Values.Add(5);
    ds3.Values.Add(1);
    ds3.Values.Add(3);
    GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart schart = new GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300);
    schart.DataSeries.Add(ds1);
    schart.DataSeries.Add(ds2);
    schart.DataSeries.Add(ds3);
    this.gcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart);
    VB.NET
    Copy Code
    Dim ds1 As New GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries()
    ds1.Values = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
    ds1.Values.Add(2)
    ds1.Values.Add(3)
    ds1.Values.Add(5)
    Dim ds2 As New GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries()
    ds2.Values = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
    ds2.Values.Add(3)
    ds2.Values.Add(6)
    ds2.Values.Add(4)
    Dim ds3 As New GrapeCity.Windows.SpreadSheet.Data.SpreadDataSeries()
    ds3.Values = New GrapeCity.Windows.SpreadSheet.Data.DoubleSeriesCollection()
    ds3.Values.Add(5)
    ds3.Values.Add(1)
    ds3.Values.Add(3)
    Dim schart As New GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChart("SChart", GrapeCity.Windows.SpreadSheet.Data.SpreadSurfaceChartType.Surface, 0, 0, 300, 300)
    schart.DataSeries.Add(ds1)
    schart.DataSeries.Add(ds2)
    schart.DataSeries.Add(ds3)
    GcSpreadSheet1.ActiveSheet.SurfaceCharts.Add(schart)
    See Also
    SpreadSurfaceChartType Enumeration
    SurfaceCharts Property