Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
ChartStyle Property
Collapse the table of content
Expand the table of content

ChartSheetBase.ChartStyle Property

Gets or sets the style of the chart.

Namespace:  Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)

public Object ChartStyle { get; set; }

Property Value

Type: System.Object
An integer from 1 through 48 that represents the style of the chart.

The values of the ChartStyle property correspond to the available options on the Chart Styles group on the Design tab on the Ribbon. The Design tab is available when you select a chart.

The following code example specifies the colors of the walls and floor of an existing 3-D chart sheet and sets the chart style to style 4. To run this code example, the workbook must contain a chart sheet called Chart1 of a 3-D type.

private void SetChartSheetDesign()
{
    // Add a new chart and populate source data
    Microsoft.Office.Tools.Excel.ChartSheet myChartSheet =
        Globals.Chart1.Base;

    myChartSheet.BackWall.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.LightGray.ToArgb();
    myChartSheet.SideWall.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.LightGray.ToArgb();
    myChartSheet.Floor.Format.Fill.ForeColor.RGB =
        System.Drawing.Color.Gray.ToArgb();

    myChartSheet.ChartStyle = 4;
}

Show:
© 2015 Microsoft