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




"s" wrote:

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.