hello
I have visual basic 2005 and i need to draw a chart. the thing is that i have on a form1 an excel spreadsheet on which the user inserts data, he clicks then on a command button, and the program does the calculus and stacks the results in the same spreadsheet but different cells.
Now i've created a second form which pop's out when i click another button on form1. On this form i need to draw a chart of the results that are in the sheet on form1.
I inserted in my toolbox microsoft office chart 10 and 11
and i also inserted microsotft chart control
However i don't really know how to use them and specifically i don't know how to take the data from the spreadsheet on the previous form.
if someone has any idea about the subject i'd really appreciate your help.
Thank You
I have visual basic 2005 and i need to draw a chart. the thing is that i have on a form1 an excel spreadsheet on which the user inserts data, he clicks then on a command button, and the program does the calculus and stacks the results in the same spreadsheet but different cells.
Now i've created a second form which pop's out when i click another button on form1. On this form i need to draw a chart of the results that are in the sheet on form1.
I inserted in my toolbox microsoft office chart 10 and 11
and i also inserted microsotft chart control
However i don't really know how to use them and specifically i don't know how to take the data from the spreadsheet on the previous form.
if someone has any idea about the subject i'd really appreciate your help.
Thank You