-
Notifications
You must be signed in to change notification settings - Fork 297
Supported Charts
Mats Alm edited this page Nov 6, 2023
·
7 revisions
EPPlus from version 5.2 supports all Excel 2019 chart types.
See our charts samples for how to add charts to a workbook with EPPlus.
| Chart type | Chart Style | Remark |
|---|---|---|
| Column Chart | All Excel 2019 chart styles | |
| Clustered | ||
| Stacked | ||
| 100 % Stacked | ||
| Column Chart 3D | All Excel 2019 chart styles | Box, Pyramid, Partial Pyramid, Cone, Partial Cone, Cylinder |
| Clustered | ||
| Stacked | ||
| 100 % Stacked | ||
| 3D Column | With secondary Axis | |
| Bar Chart | All Excel 2019 chart styles | |
| Clustered | ||
| Stacked | ||
| 100 % Stacked | ||
| Bar Chart 3D | All Excel 2019 chart styles | Box, Pyramid, Partial Pyramid, Cone, Partial Cone, Cylinder |
| Clustered | ||
| Stacked | ||
| 100 % Stacked | ||
| 3D Column | With secondary Axis | |
| Line Chart | All Excel 2019 chart styles | |
| Line | ||
| Stacked | ||
| 100 % stacked | ||
| Line with markers | ||
| Stacked with markers | ||
| 100 % stacked with markers | ||
| Pie Chart | All Excel 2019 chart styles | |
| Pie | ||
| Pie of Pie | ||
| Bar of Pie | ||
| Pie 3D | ||
| Pie Exploded | ||
| Doughnut Chart | ||
| Area Chart | All Excel 2019 chart styles | |
| Area | ||
| Stacked | ||
| 100 % stacked | ||
| Area 3D Chart | All Excel 2019 chart styles | |
| Area | ||
| Stacked | ||
| 100 % stacked | ||
| Scatter Chart | ||
| Scatter | All Excel 2019 chart styles | |
| With smooth lines | ||
| With smooth lines and markers | ||
| With stright lines | ||
| With stright lines and markers | ||
| Bubble Chart | All Excel 2019 chart styles | |
| Bubble | ||
| Bubble 3D | ||
| Stock Chart | All Excel 2019 chart styles | |
| High-Low-Close | ||
| Open-High-Low-Close | ||
| Volume-High-Low-Close | ||
| Volume-Open-High-Low-Close | ||
| Surface Chart | Limited | |
| Surface | ||
| Wireframe 3D | ||
| Contour | ||
| Wireframe contour | ||
| Radar Chart | All Excel 2019 chart styles | |
| Radar | ||
| With markers | ||
| Filled | ||
| Sunburst Chart | All Excel 2019 chart styles | |
| Treemap Chart | All Excel 2019 chart styles | |
| Histogram Chart | All Excel 2019 chart styles | |
| Histogram | ||
| Histogram with Pareto line | ||
| Box & Whisker Chart | All Excel 2019 chart styles | |
| Waterfall Chart | All Excel 2019 chart styles | |
| Funnel Chart | All Excel 2019 chart styles | |
| Region Map Chart | All Excel 2019 chart styles | EPPlus relies on Excel to create the map data. |
EPPlus Software AB - https://epplussoftware.com
- What is new in EPPlus 5+
- Breaking Changes in EPPlus 5
- Breaking Changes in EPPlus 6
- Breaking Changes in EPPlus 7
- Breaking Changes in EPPlus 8
- Addressing a worksheet
- Dimension/Used range
- Copying ranges/sheets
- Insert/Delete
- Filling ranges
- Sorting ranges
- Taking and skipping columns/rows
- Data validation
- Comments
- Freeze and Split Panes
- Header and Footer
- Hyperlinks
- Autofit columns
- Grouping and Ungrouping Rows and Columns
- Formatting and styling
- The ExcelRange.Text property
- Conditional formatting
- Using Themes
- Working with custom named table- or slicer- styles