Home » Support » Samples » ASP.NET Samples » Excel Reporting Samples » Excel Report with Chart Linked to Defined Name

ASP.NET Samples

Excel Report with Chart Linked to Defined Name

This sample shows how to load a workbook containing a chart series linked to a defined name, change the defined name range reference, and stream it to Microsoft Excel. For charts with multiple series, use Excel to set each chart series to refer to a unique defined name.

[Run Sample] | [View Template]

Download SpreadsheetGear

Copyright © 2003-2019 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.

SpreadsheetGear 2017 adds a new SpreadsheetGear for .NET Standard product, official support for Excel 2019 and Excel for Office 365, 51 new Excel functions, full conditional formatting support, enhanced workbook protection and encryption, cell gradient rendering and more.

"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

"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

"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

"ASP.NET and Microsoft Excel is a dangerous combination. ASP.NET and SpreadsheetGear is a match made in heaven. When you need your web or Windows app to interact with Excel files with lightening speed and no COM crashes, SpreadsheetGear for .NET is what you use. This product truly separates the men from the boys in the spreadsheet control marketplace."

Robbe Morris
Microsoft MVP - C#
Co-founder of EggHeadCafe.com and former Gartner Sr. Software Engineer

We’ve been using SpreadsheetGear for 5 years. One of the things that makes this product special is that I really don’t have to think about it – I can spend my time worrying about the application that wraps it rather than the technology itself.

The vendor is great to work with too – technical questions are addressed quickly and accurately, without a lot of the refusal to admit problems that plagues other vendors.

Great job!!!

Bill Wilson
Development Manager
Thomson Reuters

I conducted a three month analysis comparing three top spreadsheet controls for .NET application developers: SpreadsheetGear, SyncFusion XlsIO, and ComponentOne Spread.NET. The definite winner was SpreadsheetGear, with ComponentOne Spread.NET in second. SpreadsheetGear provides the most Excel-like experience, is the most performant, and provides the most responsive and capable product support.

I build a reporting engine for my company and SpreadsheetGear made it awesome. Our customers have been very pleased. I wanted to share my extensive analysis with any other developers out there trying to find the right spreadsheet control for their .NET application.

Joseph Fluckiger
Sr. Software Architect
Thermo Fisher Scientific
Austin, TX

ASP.NET Samples

Excel Report with Chart Linked to Defined Name

SpreadsheetGear Samples and Tutorials

Download SpreadsheetGear

Licensed Users

Free 30-Day Evaluation