ChartObject.Style Property

Returns or specifies the chart style.

Namespace: DevExpress.Spreadsheet.Charts

Assembly: DevExpress.Spreadsheet.v21.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

ChartStyle Style { get; set; }

VB.NET

Property Style As ChartStyle

Property Value

Type	Description
ChartStyle	An enumeration value that defines a style to apply to the chart.

Available values:

Show 58 items

Name	Description
Gray	A monochromatic chart style that applies different shades of the Dark1 theme color to each data series.
GrayOutline	A monochromatic chart style that applies different shades of the Dark1 theme color to each data series and specifies shape outlines.
GrayGradient	A monochromatic chart style that applies different shades of the Dark1 theme color with a gradient effect to each data series.
GrayBevel	A monochromatic chart style that applies different shades of the Dark1 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
GrayArea	A monochromatic chart style that applies different shades of the Dark1 theme color to each data series and uses 20% tint of this color to fill the plot area.
GrayDark	A monochromatic chart style that applies different shades of the Dark1 theme color to each data series and uses this color to fill the chart area.
Color	A colorful chart style that applies one of six accent colors defined by the document’s theme to each data series.
ColorOutline	A colorful chart style that applies one of six accent colors to each data series and specifies shape outlines.
ColorGradient	A colorful chart style that applies one of six accent colors with a gradient effect to each data series.
ColorBevel	A colorful chart style that applies one of six accent colors to each data series and specifies shape effects (such as beveled edges and shadows).
ColorArea	A colorful chart style that applies one of six accent colors to each data series and uses 20% tint of the Dark1 theme color to fill the plot area.
ColorDark	A colorful chart style that applies one of six accent colors and shape effects to each data series, and uses the Dark1 theme color to fill the chart area.
Accent1	A monochromatic chart style that applies different shades of the Accent1 theme color to each data series.
Accent1Outline	A monochromatic chart style that applies different shades of the Accent1 theme color to each data series and specifies shape outlines.
Accent1Gradient	A monochromatic chart style that applies different shades of the Accent1 theme color with a gradient effect to each data series.
Accent1Bevel	A monochromatic chart style that applies different shades of the Accent1 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent1Area	A monochromatic chart style that applies different shades of the Accent1 theme color to each data series and uses this color to fill the plot area.
Accent1Dark	A monochromatic chart style that applies different shades of the Accent1 theme color and shape effects to each data series. This style uses the Dark1 theme color to fill the chart area.
Accent2	A monochromatic chart style that applies different shades of the Accent2 theme color to each data series.
Accent2Outline	A monochromatic chart style that applies different shades of the Accent2 theme color to each data series and specifies shape outlines.
Accent2Gradient	A monochromatic chart style that applies different shades of the Accent2 theme color with a gradient effect to each data series.
Accent2Bevel	A monochromatic chart style that applies different shades of the Accent2 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent2Area	A monochromatic chart style that applies different shades of the Accent2 theme color to each data series and uses this color to fill the plot area.
Accent2Dark	A monochromatic chart style that applies different shades of the Accent2 theme color and shape effects to each data series. This style uses the Dark1 theme color to fill the chart area.
Accent3	A monochromatic chart style that applies different shades of the Accent3 theme color to each data series.
Accent3Outline	A monochromatic chart style that applies different shades of the Accent3 theme color to each data series and specifies shape outlines.
Accent3Gradient	A monochromatic chart style that applies different shades of the Accent3 theme color with a gradient effect to each data series.
Accent3Bevel	A monochromatic chart style that applies different shades of the Accent3 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent3Area	A monochromatic chart style that applies different shades of the Accent3 theme color to each data series and uses this color to fill the plot area.
Accent3Dark	A monochromatic chart style that applies different shades of the Accent3 theme color and shape effects to each data series. This chart style uses the Dark1 theme color to fill the chart area.
Accent4	A monochromatic chart style that applies different shades of the Accent4 theme color to each data series.
Accent4Outline	A monochromatic chart style that applies different shades of the Accent4 theme color to each data series and specifies shape outlines.
Accent4Gradient	A monochromatic chart style that applies different shades of the Accent4 theme color with a gradient effect to each data series.
Accent4Bevel	A monochromatic chart style that applies different shades of the Accent4 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent4Area	A monochromatic chart style that applies different shades of the Accent4 theme color to each data series and uses this color to fill the plot area.
Accent4Dark	A monochromatic chart style that applies different shades of the Accent4 theme color and shape effects to each data series. This chart style uses the Dark1 theme color to fill the chart area.
Accent5	A monochromatic chart style that applies different shades of the Accent5 theme color to each data series.
Accent5Outline	A monochromatic chart style that applies different shades of the Accent5 theme color to each data series and specifies shape outlines.
Accent5Gradient	A monochromatic chart style that applies different shades of the Accent5 theme color with a gradient effect to each data series.
Accent5Bevel	A monochromatic chart style that applies different shades of the Accent5 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent5Area	A monochromatic chart style that applies different shades of the Accent5 theme color to each data series and uses this color to fill the plot area.
Accent5Dark	A monochromatic chart style that applies different shades of the Accent5 theme color and shape effects to each data series. This chart style uses the Dark1 theme color to fill the chart area.
Accent6	A monochromatic chart style that applies different shades of the Accent6 theme color to each data series.
Accent6Outline	A monochromatic chart style that applies different shades of the Accent6 theme color to each data series and specifies shape outlines.
Accent6Gradient	A monochromatic chart style that applies different shades of the Accent6 theme color with a gradient effect to each data series.
Accent6Bevel	A monochromatic chart style that applies different shades of the Accent6 theme color to each data series and specifies shape effects (such as beveled edges and shadows).
Accent6Area	A monochromatic chart style that applies different shades of the Accent6 theme color to each data series and uses this color to fill the plot area.
Accent6Dark	A monochromatic chart style that applies different shades of the Accent6 theme color and shape effects to each data series. This chart style uses the Dark1 theme color to fill the chart area.
Custom	A custom chart style. Use the Chart.LoadStyle method to load a custom style from a file.
Style1	Corresponds to Style 1 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style2	Corresponds to Style 2 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style3	Corresponds to Style 3 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style4	Corresponds to Style 4 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style5	Corresponds to Style 5 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style6	Corresponds to Style 6 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, box and whisker, histogram, sunburst, funnel, Pareto, and treemap.
Style7	Corresponds to Style 7 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, sunburst, funnel, and treemap.
Style8	Corresponds to Style 8 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: waterfall, sunburst, funnel, and treemap.
Style9	Corresponds to Style 9 from the Chart Styles gallery in Microsoft® Excel® 2016 and higher. Applies to the following chart types: funnel and treemap.

Remarks

Use the Style property to apply one of the predefined styles to an existing chart. Each style specifies data series colors, sets the chart’s background fill, and applies different shape effects and outlines to the chart.

The chart appearance to which a style is applied depends on the current document theme. Each theme has a color palette used to specify chart colors. You can select a colorful chart style that applies one of six accent colors to each series, or use a monochromatic style that applies different shades of the same color to each series.

The example below demonstrates how to create a chart and apply one of the predefined styles to it using the ChartObject.Style property.

View Example

StyleActions.cs

Worksheet worksheet = workbook.Worksheets["chartTask3"];
workbook.Worksheets.ActiveWorksheet = worksheet;

// Create a chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet["B2:D4"]);
chart.TopLeftCell = worksheet.Cells["H2"];
chart.BottomRightCell = worksheet.Cells["N14"];

// Set the chart style.
chart.Style = ChartStyle.Accent1Dark;

StyleActions.vb

Dim worksheet As Worksheet = workbook.Worksheets("chartTask3")
workbook.Worksheets.ActiveWorksheet = worksheet

' Create a chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.ColumnClustered, worksheet("B2:D4"))
chart.TopLeftCell = worksheet.Cells("H2")
chart.BottomRightCell = worksheet.Cells("N14")

' Set the chart style.
chart.Style = ChartStyle.Accent1Dark

Excel 2016 Chart Styles

Use styles from Style1 to Style9 for Excel 2016 charts. The following table lists supported styles for each chart:

Chart Type	Supported Styles
Waterfall	Style1 through Style8
Box and Whisker	Style1 through Style6
Histogram	Style1 through Style6
Pareto	Style1 through Style6
Sunburst	Style1 through Style8
Funnel	Style1 through Style9
Treemap	Style1 through Style9

The ChartObject.ColorPalette property allows you to change chart colors.

The example below demonstrates how to create a waterfall chart and specify its colors and style.

C#

// Create a waterfall chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.Waterfall, worksheet["B2:C7"]);
chart.TopLeftCell = worksheet.Cells["E2"];
chart.BottomRightCell = worksheet.Cells["L17"];

// Hide the major gridlines for the value axis.
chart.PrimaryAxes[1].MajorGridlines.Visible = false;

// Specify series options.
var options = chart.Series[0].LayoutOptions.Waterfall;
// Display connector lines.
options.ShowConnectorLines = true;
// Set the third data point as the total.
options.SubtotalDataPoints.Add(2);
// Set the last data point as the total.
options.SubtotalDataPoints.Add(5);

// Specify the chart style.
chart.Style = ChartStyle.Style3;
// Change chart colors.
chart.ColorPalette = ChartColorPalette.Colorful4;

// Add the chart title.
chart.Title.Visible = true;
chart.Title.SetValue("Income Statement");

VB.NET

' Create a waterfall chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.Waterfall, worksheet("B2:C7"))
chart.TopLeftCell = worksheet.Cells("E2")
chart.BottomRightCell = worksheet.Cells("L17")

' Hide the major gridlines for the value axis.
chart.PrimaryAxes(1).MajorGridlines.Visible = False

' Specify series options.
Dim options As WaterfallSeriesOptions = chart.Series(0).LayoutOptions.Waterfall
' Display connector lines.
options.ShowConnectorLines = True
' Set the third data point as the total.
options.SubtotalDataPoints.Add(2)
' Set the last data point as the total.
options.SubtotalDataPoints.Add(5)

' Specify the chart style.
chart.Style = ChartStyle.Style3
' Change chart colors.
chart.ColorPalette = ChartColorPalette.Colorful4

' Add the chart title.
chart.Title.Visible = True
chart.Title.SetValue("Income Statement")

Custom Style

Use the ChartObject.LoadStyle method to load a custom style from an XML file and apply it to an Excel 2016 chart.

The code sample below applies a custom style to a waterfall chart. The style.xml file contains a definition of a standard style used for histogram and funnel charts.

C#

// Create a waterfall chart and specify its location.
Chart chart = worksheet.Charts.Add(ChartType.Waterfall, worksheet["B2:C7"]);
chart.TopLeftCell = worksheet.Cells["E2"];
chart.BottomRightCell = worksheet.Cells["L17"];

// Hide the major gridlines for the value axis.
chart.PrimaryAxes[1].MajorGridlines.Visible = false;

// Specify series options.
var options = chart.Series[0].LayoutOptions.Waterfall;
// Display connector lines.
options.ShowConnectorLines = true;
// Set the third data point as the total.
options.SubtotalDataPoints.Add(2);
// Set the last data point as the total.
options.SubtotalDataPoints.Add(5);

// Load a custom style
// and apply it to the chart.
chart.LoadStyle(@"CustomStyles\style.xml");

// Add the chart title.
chart.Title.Visible = true;
chart.Title.SetValue("Income Statement");

VB.NET

' Create a waterfall chart and specify its location.
Dim chart As Chart = worksheet.Charts.Add(ChartType.Waterfall, worksheet("B2:C7"))
chart.TopLeftCell = worksheet.Cells("E2")
chart.BottomRightCell = worksheet.Cells("L17")

' Hide the major gridlines for the value axis.
chart.PrimaryAxes(1).MajorGridlines.Visible = False

' Specify series options.
Dim options As WaterfallSeriesOptions = chart.Series(0).LayoutOptions.Waterfall
' Display connector lines.
options.ShowConnectorLines = True
' Set the third data point as the total.
options.SubtotalDataPoints.Add(2)
' Set the last data point as the total.
options.SubtotalDataPoints.Add(5)

' Load a custom style
' and apply it to the chart.
chart.LoadStyle("CustomStyles\style.xml")

' Add the chart title.
chart.Title.Visible = True
chart.Title.SetValue("Income Statement")

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the Style property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

spreadsheet-document-api-chart-examples/CS/SpreadsheetDocServerChartAPISamples/CodeExamples/CreationAndDataActions.cs#L22

// Set the chart style.
chart.Style = ChartStyle.ColorGradient;

winforms-spreadsheet-chart-api/CS/SpreadsheetChartAPISamples/CodeExamples/CreationAndDataActions.cs#L22

// Set the chart style.
chart.Style = ChartStyle.ColorGradient;

wpf-spreadsheet-chart-api/CS/SpreadsheetWPFChartAPISamples/CodeExamples/StyleActions.cs#L22

// Set the chart style.
chart.Style = ChartStyle.Accent1Dark;

spreadsheet-how-to-add-a-chart-to-a-document-t467065/CS/T449201/DiagramCreationHelper.cs#L123

// Specify the chart style
chart.Style = ChartStyle.ColorGradient;

VB.NET

spreadsheet-document-api-chart-examples/VB/SpreadsheetDocServerChartAPISamples/CodeExamples/CreationAndDataActions.vb#L26

' Set the chart style.
chart.Style = ChartStyle.ColorGradient

winforms-spreadsheet-chart-api/VB/SpreadsheetChartAPISamples/CodeExamples/CreationAndDataActions.vb#L25

' Set the chart style.
chart.Style = ChartStyle.ColorGradient

wpf-spreadsheet-chart-api/VB/SpreadsheetWPFChartAPISamples/CodeExamples/StyleActions.vb#L26

' Set the chart style.
chart.Style = ChartStyle.Accent1Dark

spreadsheet-how-to-add-a-chart-to-a-document-t467065/VB/T449201/DiagramCreationHelper.vb#L123

' Specify the chart style
chart.Style = ChartStyle.ColorGradient