Enum ChartType

ChartType enumeration

Enumerates all chart types used in Excel.

public enum ChartType

Values

NameValueDescription
Area0Represents an Area Chart.
AreaStacked1Represents Stacked Area Chart.
Area100PercentStacked2Represents 100% Stacked Area Chart.
Area3D3Represents 3D Area Chart.
Area3DStacked4Represents 3D Stacked Area Chart.
Area3D100PercentStacked5Represents 3D 100% Stacked Area Chart.
Bar6Represents a Bar Chart: Clustered Bar Chart.
BarStacked7Represents Stacked Bar Chart.
Bar100PercentStacked8Represents 100% Stacked Bar Chart.
Bar3DClustered9Represents 3D Clustered Bar Chart.
Bar3DStacked10Represents 3D Stacked Bar Chart.
Bar3D100PercentStacked11Represents 3D 100% Stacked Bar Chart.
Bubble12Represents a Bubble Chart.
Bubble3D13Represents 3D Bubble Chart.
Column14Represents Column Chart: Clustered Column Chart.
ColumnStacked15Represents Stacked Column Chart.
Column100PercentStacked16Represents a 100% Stacked Column Chart.
Column3D17Represents 3D Column Chart.
Column3DClustered18Represents 3D Clustered Column Chart.
Column3DStacked19Represents 3D Stacked Column Chart.
Column3D100PercentStacked20Represents 3D 100% Stacked Column Chart.
Cone21Represents Cone Chart.
ConeStacked22Represents Stacked Cone Chart.
Cone100PercentStacked23Represents 100% Stacked Cone Chart.
ConicalBar24Represents Conical Bar Chart.
ConicalBarStacked25Represents Stacked Conical Bar Chart.
ConicalBar100PercentStacked26Represents a 100% Stacked Conical Bar Chart.
ConicalColumn3D27Represents 3D Conical Column Chart.
Cylinder28Represents a Cylinder Chart.
CylinderStacked29Represents Stacked Cylinder Chart.
Cylinder100PercentStacked30Represents a 100% Stacked Cylinder Chart.
CylindricalBar31Represents Cylindrical Bar Chart.
CylindricalBarStacked32Represents Stacked Cylindrical Bar Chart.
CylindricalBar100PercentStacked33Represents 100% Stacked Cylindrical Bar Chart.
CylindricalColumn3D34Represents 3D Cylindrical Column Chart.
Doughnut35Represents Doughnut Chart.
DoughnutExploded36Represents Exploded Doughnut Chart.
Line37Represents Line Chart.
LineStacked38Represents Stacked Line Chart.
Line100PercentStacked39Represents 100% Stacked Line Chart.
LineWithDataMarkers40Represents Line Chart with data markers.
LineStackedWithDataMarkers41Represents Stacked Line Chart with data markers.
Line100PercentStackedWithDataMarkers42Represents 100% Stacked Line Chart with data markers.
Line3D43Represents 3D Line Chart.
Pie44Represents Pie Chart.
Pie3D45Represents 3D Pie Chart.
PiePie46Represents the pie of a pie chart.
PieExploded47Represents Exploded Pie Chart.
Pie3DExploded48Represents 3D Exploded Pie Chart.
PieBar49Represents Bar of Pie Chart.
Pyramid50Represents a Pyramid Chart.
PyramidStacked51Represents Stacked Pyramid Chart.
Pyramid100PercentStacked52Represents 100% Stacked Pyramid Chart.
PyramidBar53Represents Pyramid Bar Chart.
PyramidBarStacked54Represents Stacked Pyramid Bar Chart.
PyramidBar100PercentStacked55Represents 100% Stacked Pyramid Bar Chart.
PyramidColumn3D56Represents 3D Pyramid Column Chart.
Radar57Represents Radar Chart.
RadarWithDataMarkers58Represents a Radar Chart with data markers.
RadarFilled59Represents Filled Radar Chart.
Scatter60Represents a Scatter Chart.
ScatterConnectedByCurvesWithDataMarker61Represents Scatter Chart connected by curves, with data markers.
ScatterConnectedByCurvesWithoutDataMarker62Represents a Scatter Chart connected by curves, without data markers.
ScatterConnectedByLinesWithDataMarker63Represents Scatter Chart connected by lines, with data markers.
ScatterConnectedByLinesWithoutDataMarker64Represents Scatter Chart connected by lines, without data markers.
StockHighLowClose65Represents High-Low-Close Stock Chart.
StockOpenHighLowClose66Represents Open-High-Low-Close Stock Chart.
StockVolumeHighLowClose67Represents Volume-High-Low-Close Stock Chart.
StockVolumeOpenHighLowClose68Represents Volume-Open-High-Low-Close Stock Chart.
Surface3D69Represents Surface Chart: 3D Surface Chart.
SurfaceWireframe3D70Represents Wireframe 3D Surface Chart.
SurfaceContour71Represents Contour Chart.
SurfaceContourWireframe72Represents Wireframe Contour Chart.
BoxWhisker73The series is laid out as box and whisker.
Funnel74The series is laid out as a funnel.
ParetoLine75The series is laid out as pareto lines.
Sunburst76The series is laid out as a sunburst.
Treemap77The series is laid out as a treemap.
Waterfall78The series is laid out as a waterfall.
Histogram79The series is laid out as a histogram.
Map80The series is laid out as a region map.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Charts;
    using System;

    public class ChartTypeDemo
    {
        public static void ChartTypeExample()
        {
            // Create a new workbook
            Workbook workbook = new Workbook();
            // Get the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            // Add some sample data
            worksheet.Cells[0, 0].PutValue("Category");
            worksheet.Cells[0, 1].PutValue("Value");
            worksheet.Cells[1, 0].PutValue("A");
            worksheet.Cells[1, 1].PutValue(10);
            worksheet.Cells[2, 0].PutValue("B");
            worksheet.Cells[2, 1].PutValue(20);
            worksheet.Cells[3, 0].PutValue("C");
            worksheet.Cells[3, 1].PutValue(30);

            // Add a chart to the worksheet
            int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5);
            Chart chart = worksheet.Charts[chartIndex];

            // Set the data range for the chart
            chart.SetChartDataRange("A1:B4", true);

            // Set chart title
            chart.Title.Text = "Sample Chart";

            // Customize the chart type
            chart.Type = ChartType.Column3DClustered;

            // Save the workbook
            workbook.Save("ChartTypeExample.xlsx");
            workbook.Save("ChartTypeExample.pdf");
        }
    }
}

See Also