help to display the graph from data exported in excel

[SHIVPREET2K1]

Dear friends

I have created a project in which i exported the data of access to ms excel but what i want that it should also display a graph there based on that data


plz help me regarding this


Thanks in advance


Shivpreet2k1

[dglienna]

Just record a MACRO that does the hard part. Then EDIT the macro to get the code that does the work. If you have a problem translating it, post back.
That's the way I always do things.

[SHIVPREET2K1]

hi Friend

Could u provide an example so that i may clearly understand what r u saying

Thanks in advance


Shivpreet2k1

[dglienna]

It would be hard for me to do as I don't have a graph to import.
Just click Tools -> Macro - > Record New Macro. Give it a name, and then use Excel to import the graph into your worksheet. Then click the Red STOP button.
Then go back to Tools -> Macro - > Macros, select it from the list, and click EDIT.

Copy this code into your app, but you might have to modify it to have it work in VB. Post back with any problems. You could also search the forums. It may have been discussed before.