SpreadsheetGear - performance spreadsheet components
Home | Contact | Site Map | Download | Purchase
Products
SpreadsheetGear 2010
Purchase SpreadsheetGear
Samples
ASP.NET Samples
Windows Forms Samples
Downloads
Licensed Users Downloads
Download 30-Day Evaluation
Support
FAQ
How To
Documentation
Submit Issues
Company
Home Page
About Us
Contact
Resellers
Privacy
News
Excel Charting Samples
Enable users to visualize data by adding Excel charts to reports
Click for larger image of a chart generated by SpreadsheetGear 2010 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 2010's comprehensive Excel compatible charting support.
  
Dynamic Chart Gallery
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.
[Run Sample] | [C# Source] | [VB.NET Source] | [View XLSX]
  
Basic Chart (Open XML)
This sample shows how to create a new workbook, add some values, add a chart, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Stock Chart (Open XML)
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.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Stacked Combination Chart (Open XML)
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.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Gantt Chart (Open XML)
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.
[Run Sample] | [C# Source] | [VB.NET Source]
  
3D Cylinder Chart (Open XML)
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.
[Run Sample] | [C# Source] | [VB.NET Source]
  
Excel Report with Formatted Chart (Open XML)
This sample shows how to create a new workbook, add some values, add a chart, format the chart, and stream it to Microsoft Excel.
[Run Sample] | [C# Source] | [VB.NET Source]
  
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.
[Run Sample] | [C# Source] | [VB.NET Source] | [View Template]
Like SpreadsheetGear?
SpreadsheetGear 2010
Now Available
NEW!  Autofilters, password protected workbooks, macro-enabled Open XML (.xlsm) support, Excel 2010 support, Visual Studio 2010 and .NET 4.0 support, a number of charting features and more.

Download the FREE Trial.
Microsoft Chooses
SpreadsheetGear for .NET
"After carefully evaluating SpreadsheetGear, Excel Services, and other 3rd party options, we ultimately chose SpreadsheetGear for .NET because it is the best fit for MSN Money."

Chris Donohue
Program Manager
MSN Money
Spreadsheet Component
Industry Veterans
"Our key developers have over fifty years of combined experience developing high performance commercially available spreadsheet technology which is used by most of the Fortune 500."

Joe Erickson
Founder and CEO
SpreadsheetGear LLC
Reduced Time From
20 Minutes to 4 Seconds
"We integrated SpreadsheetGear for .NET with an existing application with about two days work and it reduced the time it takes to generate a critical daily report from 20 minutes to 4 seconds. Thanks for making my team look like miracle workers!"

Luke Melia, Software
Development Manager
Oxygen Media, New York
First Rate Support
Superior Control
"Your support is first rate. We always get an answer within a few minutes of any request or question. This support, combined with the exceptional speed and ease of use of your superior control enables me to create complex spreadsheet solutions that work in a few minutes instead of days. Keep up the excellent work!"

Greg Newman
WSFS Bank
Newark DE
Hands Down the Most
Intuitive and Easy to Use
"Thanks again for your prompt response, and I would just like to say that this is by far the best library that I have worked with. It is hands down the most intuitive and easy to use API that I have used to work with Excel files. Its performance is hard to beat as well.”

Levi Wilson
Software Developer
Press Ganey Associates
South Bend, Indiana
Vision and Ability for Advanced Spreadsheets
September 20, 2005 - "With SpreadsheetGear, we finally have a company that understands our requirements in regards to supporting the Microsoft Excel file format in the Microsoft .NET Framework. SpreadsheetGear has the vision and the ability to provide the advanced spreadsheet functionality our customers expect in our products."

Tim Tow
President
Applied OLAP, Inc.
Former Microsoft Excel MVP
Creating Excel Reports
Has Never Been Easier
"I really am happy with SpreadsheetGear for .NET. It works fantastic, very smooth to handle. Creating Excel Reports has never been easier for me!"

Wolfgang Kamir
Softwaretailor
Baden, Lower Austria
SpreadsheetGear - The
Best I Have Encountered
"The sample code you provided has worked very well indeed. Many thanks for your help. As a developer of bespoke software I can honestly say that of all the components my company has ever used, SpreadsheetGear is the best that I have encountered."

Peter Rose, Director
TEKenable, Ltd.
Dublin, Ireland
I'm Impressed With the
Ease of Use and Speed
"I'm impressed with the ease of use and speed of SpreadsheetGear for .NET in rendering large workbooks from a web page. Congrats for your work!"

José M. Marcenaro
Tercer Planeta
Buenos Aires, Argentina
Fantastic -- From Excel
To ASP.NET Dashboard
in a Single Afternoon
"Fantastic evaluation -- I started with a customer’s Excel workbook with a dashboard containing variable cells and a chart. Using SpreadsheetGear, and your Dashboard from 1693 Analytics sample as a template, I created my own ASP.NET page to display our client’s dashboard, and update based on the selection of parameters which get plugged into the variable cells. And I got this working in a single afternoon."

Andy Hofer
Directory of Development
NST Systems, Inc.
Stamford, CT
Copyright © 2003-2011 SpreadsheetGear LLC. All Rights Reserved.
SpreadsheetGear® is a registered trademark and Spreadsheet Gear is a trademark of SpreadsheetGear LLC.
Microsoft, Microsoft Excel, Visual Studio and the Visual Studio logo are trademarks or registered trademarks of Microsoft Corporation in the United States and/or other countries.