My client is a mortgage broker who refinances loans for their client. I am developing an application which project terms, interest paid etc on clients existing loans and how a new plan can improve their financial standings. I showing existing loans and new loan summary in a DataGrid using DataTable, i.e. creating monthly entries (including their repayments, interest charged etc) over the period of term.
Now I want to show each existing loans and new plan on a Line Graph. How can I do that I want the data values for the graph to be taken from the DataGrid’s (column “Date” values on X axis and column “Repayments” values on Y axis) for each existing loan and new plan. Are there any controls in .NET which I can use for creating Line graph on a form I want to dynamically create graphs as there can be multiple loans and plans for a client. I could not find any helpful material on the web as well.
I am really baffled, should I use Crystal Reports, Microsoft Office Web Components, is there any control shipped with .NET I am totally lost, please set me in right direction.
Thanx

Graphs in .NET
ZMAN!!
If you know that your end user will have Office installed, Excel automation is a very viable solution. Then the final graph can be saved as a spreadsheet. Plus if you are familiar with charting in Excel then you already know how to create the graph.
If all you need is a simple line graph it seems it would be a fairly simple matter to make a user control that draws the graph. I mean, you basically just need to plot the points and draw colored lines... that's easy enough in GDI.
pathakn
In order to save yourself (or client) some time and money I recommend purchasing a graphics control. I'm using graphics server (www.graphicsserver.com) and am very happy with the product and support. The cost is $700 for a developer license for both the winforms and asp.net graph controls with no runtime charges.
Amit Puri
I know my replay it is a little bit late and you might solved your problem until now but you can check out netCharting at the following address:
http://www.dotnetcharting.com/
Hope this helps. :)