ASP and Excel Chart
I export my data to excel from web and I want it to automatically chart graph for me.
-t-
[152 byte] By [Lieternour] at [2007-11-17 13:07:13] 
Does anybody has a sample code for charting data?
I export my data to excel from web and I want it to automatically chart graph for me.
-t-
# 1 Re: ASP and Excel Chart
You will need to use Excel Automation. As to what code to write for the Excel portion, the easiest way to get to the code is by using the Macro tools.Open up Excel. Enter your data. Go to Tools->Macro->Record New Macro. Then start doing whatever you would need to do to generate the graphs. Click End Macro. Press Alt+F11. This should bring up the Visual Basic editor which will have the necessary VB code, that you should be able to use in your program.
Does this help ?
SatyaV at 2007-11-9 11:37:10 >
