Excel Charting
Enable users to visualize data by adding Excel charts to reports
Richly formatted workbooks with fast and complete calculations are the heart and soul of a spreadsheet, but the ability to make good decisions is greatly enhanced by the ability to visualize data. Enhance your users' understanding of their data by taking advantage of SpreadsheetGear's comprehensive Excel compatible charting support.
Dynamic Chart Gallery Samples
This sample dynamically creates a chart gallery using a mix of server-side Razor Pages and client-side JavaScript Ajax calls, which demonstrates rendering some of the most commonly used Excel charting features from a single Excel 2007-2019 Open XML workbook.
Basic Chart Samples
This sample shows how to create a new workbook, add some values, add a chart, and stream it to Microsoft Excel.
Stock Chart Samples
This sample shows how to create a new workbook, copy data from a DataTable, add a stock chart, use various formatting to format the chart, and stream it to Microsoft Excel.
Stacked Combination Chart Samples
This sample shows how to create a new workbook, add some values, add a chart, use multiple chart groups and multiple axes groups to create a stacked combination chart, and stream it to Microsoft Excel.
Gantt Chart Samples
This sample shows how to create a new workbook, add some values, add a chart, use stacked bars and various formatting to simulate a gantt chart, and stream it to Microsoft Excel.
3D Cylinder Chart Samples
This sample shows how to create a new workbook, add some values, add a cylinder chart, change 3D view settings, and stream it to Microsoft Excel.
Excel Report with Formatted Chart Samples
This sample shows how to create a new workbook, add some values, add a chart, format the chart, and stream it to Microsoft Excel.
Excel Report with Chart (From Template Workbook) Samples
This sample shows how to load a workbook containing a chart, add some values, and stream it to Microsoft Excel.
Quick-Fill