Results 1 to 3 of 3
  1. #1
    Lounger
    Join Date
    Feb 2001
    Location
    Middletown, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Accessing graphs created by the graph wizard (Excel 97 SR-1)

    Is there a way to access graphs created by the wizard? In other words, where is the code stored and can I modify it?
    Thanks for any suggestions

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Accessing graphs created by the graph wizard (Excel 97 SR-1)

    When you use the Chart Wizard, no code is generated unless you set the macro recorder on before you start. To do that, goto Tools, Macro, Record New macro. Enter a name for the macro and click OK. Then start the chart wizard and design your chart. when finished, go back to Tools, Macro and select Stop recording. Then goto Tools, Macro, Macros, and select the name of your macro and then select Edit. You should now see the code that created your chart.

    Hope you can follow that.

    Andrew C

  3. #3
    Lounger
    Join Date
    Feb 2001
    Location
    Middletown, New Jersey, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Accessing graphs created by the graph wizard (Excel 97 SR-1)

    Thanks a lot and also for the quick response

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •