Click here to Skip to main content
15,897,334 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Hi all,

can anybody help me to create a trend (line graph) in a Windows form using vb.my data is in excel sheet.i am using VS2008.

thanks in advance.

regards,

Danny
Posted

1 solution

You have a few options;

1) Use Office interop to directly work with the excel sheet and create an excel chart

2) Use Office interop to read the data from the excel sheet and create a chart using MSChart control in your app

3) Save the data in your excel sheet out to another format, and read into your app and create the chart in your app with MSChart

4) Depending on the source layout it is possible to use database connection to the excel sheet to get hold of the data and then create the chart.

Search CodeProject or Google for keywords around those areas, there are plenty of example to be had.
 
Share this answer
 
v3
Comments
Abhinav S 23-Jan-11 9:05am    
Good answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900