## Charts

**EPPlus 5 and up supports over 100 new chart styles introduced in Excel 2016. These styles can be easily set by the new `StyleManager` and its method `SetChartStyle` - either using the `ePresetChartStyle` enum or Excel's internal chart style number (supplied to the method as an `int`).**

### Example

```csharp
var chart = ws.Drawings.AddBarChart("column3dChart", eBarChartType.ColumnClustered3D);
var serie = chart.Series.Add(ws.Cells[2, 7, 26, 7], ws.Cells[2, 6, 26, 6]);
serie.Header = "Order Value";
chart.SetPosition(0, 0, 8, 0);
chart.SetSize(1000, 300);
chart.Title.Text = "Column Chart 3D";
//Set style 9 and Colorful Palette 3
chart.StyleManager.SetChartStyle(ePresetChartStyle.Bar3dChartStyle9, ePresetChartColors.ColorfulPalette3);
```

```vbnet
Dim chart = ws.Drawings.AddBarChart("column3dChart", eBarChartType.ColumnClustered3D)
Dim serie = chart.Series.Add(ws.Cells(2, 7, 26, 7), ws.Cells(2, 6, 26, 6))
serie.Header = "Order Value"
chart.SetPosition(0, 0, 8, 0)
chart.SetSize(1000, 300)
chart.Title.Text = "Column Chart 3D"
'Set style 9 and Colorful Palette 3
chart.StyleManager.SetChartStyle(ePresetChartStyle.Bar3dChartStyle9, ePresetChartColors.ColorfulPalette3)
```

## See also

- [Sample 5.3-C\#](<https://github.com/EPPlusSoftware/EPPlus.Samples.CSharp/tree/master/05-Drawings charts and themes/03-Charts and themes>) or \[[Sample 5.3-VB](<https://github.com/EPPlusSoftware/EPPlus.Samples.VB/tree/master/05-Drawings charts and themes/03-Charts and themes>)
- [Charts start page](<https://epplussoftware.com/docs/charts-and-drawing-objects/charts/index.md>)