Razor Page Samples - Excel Charting

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

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

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

Stock Chart

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

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

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

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

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)

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