Excel Charting Samples

Enable users to visualize data by adding Excel charts to reports

Click for larger image of a chart generated by SpreadsheetGear from a chart in an Excel workbook.

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.


This sample dynamically creates a chart gallery which demonstrates some of the most commonly used Excel charting features from a single Excel 2007-2010 Open XML workbook.

This sample shows how to create a new workbook, add some values, add a chart, and stream it to Microsoft Excel.

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.

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.

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.

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.

This sample shows how to create a new workbook, add some values, add a chart, format the chart, and stream it to Microsoft Excel.

This sample shows how to load a workbook containing a chart, add some values, and stream it to Microsoft Excel.