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.

ChartsAndThemes.xlsx

ChartsAndThemes-IntegralTheme.xlsx

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");

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);