EPPlus 5/6
Features - charts
Charts in EPPlus 5/6
EPPlus 5/6 has many new chart types and possibilities to style them compared to previous versions. All the examples below are screenshots from workbooks created with EPPlus 5/6 in our Sample projects.
These workbooks are from sample 15 and are available for download below.
Our sample project can be found here.
.NET Core ,
.NET Framework
New chart types in EPPlus 5.2
Box & Whisker
Funnel
Histogram with Pareto line
Region Map
Stockchart
Sunburst
Treemap
Waterfall
Other new chart types in EPPlus 5/6
Area chart
This area chart uses the new feature to apply chart style templates (.ctrx files). Ctrx files can be exported from Excel.
//Add an Area chart from a template file. The crtx file has it's own theme, so it does not change if you apply another theme.
var templateFile = new FileInfo("AreaChartStyle3.crtx");
var areaChart = (ExcelAreaChart)ws.Drawings.AddChartFromTemplate(templateFile, "areaChart");
![](/img/features//charts/AreaChart_crtx_Sample15.png)
Bar charts
This 3D bar chart uses chart style 9 and the colorful palette 3
//Set style 9 and Colorful Palette 3.
chart.StyleManager.SetChartStyle(ePresetChartStyle.Column3dChartStyle9, ePresetChartColors.ColorfulPalette3);
![](/img/features//charts/BarChart3D-Sample20.png)
Bubble charts
These bubble chart sheets are from sample 15 and shows the different appearances depending on the theme
![](/img/features//charts/BubbleChartSheet_Sample15.png)
Bubble charts (with integral theme)
![](/img/features//charts/BubbleChartSheet_Sample15_integral_theme.png)
Here are a few more screenshots from the sample project showing different chart styles.
Column charts (3D), Sample 15
![](/img/features//charts/ColumnChart3d.png)
Doughnut Charts, Sample 20
![](/img/features//charts/DoughnutChart_Sample20.png)
Line Charts, Sample 15 & 17
![](/img/features//charts/LineChart 3D_Sample15.png)
![](/img/features//charts/LineChart_Sample17.png)
![](/img/features//charts/LineChart 3D_Sample15.png)
![](/img/features//charts/LineChart_With_DropLines_Sample15.png)
![](/img/features//charts/LineChart_With_Error_Bars_Sample15.png)
![](/img/features//charts/LineChart_With_High_Low_Lines_Sample15.png)
![](/img/features//charts/LineChart_With_Up_Down_Bars_Sample15.png)
Pie Charts, Sample 7, 18 & 20
![](/img/features//charts/PieChart_Sample20.png)
![](/img/features//charts/PieChart_Sample7.png)
Pivot Charts
![](/img/features//charts/PivotChart_Sample18.png)
Radar Charts, Sample 15
![](/img/features//charts/RadarChartSheet_Sample15.png)
Radar Charts (integral theme)
![](/img/features//charts/RadarChartSheet_Sample15_Integral_Theme.png)
Scatter Chart with trendline, Sample 15
![](/img/features//charts/ScatterChart_with_Trendline_Sample15.png)