Hi, Gerald,
I've used MS Chart and Excel Automation at different times and they both work well.
For more advanced charting, my tool of choice is actually Crystal Reports. CR has a great charting tool, and you can integrate reports and graphs into one piece of output. CR does has a fairly steep learning curve.
Kevin