View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
EBB EBB is offline
external usenet poster
 
Posts: 1
Default How do I view and edit the source code for a Chart in Excel 2003?

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.