This article explains how to create a 3D surface chart in Excel using XlsIO.
What is a 3D surface chart?
3-D Surface chart shows a 3-D view of the data, which can be imagined as a rubber sheet stretched over a 3-D Column chart. It is typically used to show relationship between large amount of data that may otherwise be difficult to see. Color bands in a surface chart indicate the difference between values.
3D surface chart created using XlsIO
To create a 3D surface chart in Excel using XlsIO, you need to do the following steps.
Steps to create 3D surface chart
Create a chart object by calling the worksheet.Charts.Add method.
Note: For creating a 3D surface chart, the series count must be greater than or equal to 2. The series should be set before selecting the chart type.
Add the basic elements like chart title, data labels and legend.
Add the 3D chart elements like Rotation, Elevation and Perspective.
Additional applicable properties of 3D surface chart in Excel
The following C#/ VB.NET complete code snippet shows the creation of 3D surface chart using XlsIO.
|Article ID:||Published Date:||Last Revised Date:||Platform:||Control:|