Features - charts
Charts in EPPlus 5
EPPlus 5 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 in our Sample projects.
These workbooks are from sample 15 and are available for download below.
New chart types in EPPlus 5.2
Histogram with Pareto line
Other new chart types in EPPlus 5
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");
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);
These bubble chart sheets are from sample 15 and shows the different appearances depending on the theme
Bubble charts (with integral theme)
Here are a few more screenshots from the sample project showing different chart styles.