http://support.microsoft.com/default...b;en-us;157940
XL97: How To Create a Dynamic Chart Using Visual Basic

Information is pertinent to xl97 - latest versions

--
Regards,
Tom Ogilvy




"april27" wrote:

i have a macro for an excel spreadsheet. i want the macro to get data from
cells and create predefined charts based on the info in the excel sheet. does
anyone know how to do this? I cannot record a macro since the cells that are
to be used are different every time. would really appreciate help!