How do I view and edit the source code for a Chart in Excel 2003?

[EBB]

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.

 

[Nick Hodge]

EBB

Excel does not create VBA when creating a chart unless you have specifically
recorded the steps of creating it (Tools>Macros>Record 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
(e-mail address removed)
www.nickhodge.co.uk

 

[Jon Peltier]

You could try this utility, which alters the series formula:

http://peltiertech.com/Excel/Charts/XYAreaChart2.html

If the chart's data is contained on the same sheet that the chart is
embedded in, the easiest way to make another chart like it with different
data is to copy the entire sheet, then change the data on the copy of the
sheet. The chart will update as the data is changed.

- Jon