graphs with macro??

[Guest]

Hi I am new to macros..
Is it possible to use a macro to create graphs?

Like, do i mark the data i want to use and then record a macro?

greatful for advice..

S.

 

[Guest]

Thanks Tom,
This looks very good.
I will give it a try and hope that I figure it out!

Regards
Sara

that is a good way to start.

here is some sample code:
http://support.microsoft.com/?kbid=157940
XL97: How To Create a Dynamic Chart Using Visual Basic

also see this site: [Jon Peltier]
http://peltiertech.com/

--
Regards,
Tom Ogilvy

Hi I am new to macros..
Is it possible to use a macro to create graphs?

Like, do i mark the data i want to use and then record a macro?

greatful for advice..

S.