Excel is not a server application. Asking it to be a "chart server" for your web application is not going to lead to a scalable application. I would suggest either:

1) creating your own charts directly, which is possible using the Graphics namespace. Create images based on form data, and stream them right back to the user, or

2) get an ASP.NET compatible charting component.

Hi, tgreer. Thanks alot for the reply. However, I have a problem. I went to the ASP.NET compatible charting component link. Because I need to draw line chart, so I clicked the line charts link. I saw one component that seems compatible enough for my project, the TimeDataPlot. Unfortunately, it couldn't be downloaded, due to unknown reason. The other suggested controls couldn't be used because they require the updated versions of ASP.NET 2006 and .NET Framework v2.0. I am using ASP.NET 2003 and .NET Framework SDK v1.1. And, can you please provide the Graphics namespace definition? I couldn't find it. Sorry for the trouble, I am a beginner using ASP.NET with VB. Thanks alot for the help.

I have no control over the asp.net website. In any case, you really need to update to .NET Framework 2.0. I understand that may not be under your control.

I have to apologize. I said "Graphics", when I meant "Drawing". Use the System.Drawing namespace.

There are a few articles on the topic, such as this one.