EBB

Excel does not create VBA when creating a chart unless you have specifically
recorded the steps of creating it (ToolsMacrosRecord New Macro...). Even
when you have done this you may need some custom hand-written code to
complete the steps with a different sheet or range, etc.

Once you have recorded the code you can view it in the vbe by pressing
Alt+F11

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
DTHIS
www.nickhodge.co.uk


"EBB" wrote in message
...
Is there a way to access the code (VBA?) for a Chart created in Excel
2003? I
have generated a complicated Chart or graph which I want to then "Copy"
and
modify to make several more which access different spreadsheets. It is
cumbersome to click in the Toggle box for the data ranges for X and Y.
Instead, I was hoping there might be a way to use Search and Replace to
change the text describing the data ranges.