Results 1 to 5 of 5

Thread: [SOLVED] EXCEL how to change the NAME of a specific Chart

Threaded View

  1. #1

    Thread Starter
    I don't do your homework! opus's Avatar
    Join Date
    Jun 2000
    Location
    Good Old Europe
    Posts
    3,863

    Resolved [SOLVED] EXCEL how to change the NAME of a specific Chart

    How is it possible to change the name of a specific existing Chart in EXCEL using VBA?

    The code should be
    VB Code:
    1. Charts(x).Name="BlaBla"
    My problem is how can I determine the x (i.e. the Number of the Chart-Object)? Since the code could be used several times the number will change.
    To make it easy, the setting of the name could be done wwhen creating the chart (or just after the " Chart.add").

    Thanks
    Last edited by opus; Sep 25th, 2004 at 04:35 AM.
    You're welcome to rate this post!
    If your problem is solved, please use the Mark thread as resolved button


    Wait, I'm too old to hurry!

Posting Permissions

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



Click Here to Expand Forum to Full Width