I am creating some reporting software that will generate excel workbooks with charts and all related data. Besides the built in libraries and .NET Office integration features, is there any other tools or code that people found useful to creating similar projects?
EDIT: I am targeting winforms.
I've used ZedGraph before, and I found it pretty good for a free library.
If you are not already aware... Microsoft released these free charting controls for .NET
http://weblogs.asp.net/scottgu/archive/2008/11/24/new-asp-net-charting-control-lt-asp-chart-runat-quot-server-quot-gt.aspx
SpreadSheetGear I never used it but it is advertised a lot
SQL Server Reporting Services.
SpreadsheetGear for .NET is an Excel compatible spreadsheet component for .NET that supports spreadsheet features as well as Excel compatible charting. You did not specify whether you are targeting WinForms or ASP.NET, but SpreadsheetGear can be used with both.
You can see a live chart gallery with charts being rendered by SpreadsheetGear here and download the evaluation software here.
Disclaimer: I own SpreadsheetGear LLC
I've worked with the Office Open XML Library (portal), which allows you to create Excel files without Office interop. Its a little hard to learn, since you have to learn the underlying document format, and Version 2.0 is still in CTP until Office14 comes out, but its a fast (performant) and free solution.
I'm using Steema TeeChart.Net. It is a very powerful chart but it is not free and not cheap (Around $760 per developer).
Syncfusion has a native .NET utility that allows for spreadsheet automation (including charting capabilities) without going through Excel.
The bundle isn't cheap or easy to use, but it is powerful.