Results 1 to 5 of 5
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Instert charth name.. (2000)

    How to insert charth name via vba code in the graph in sheet TABELLA_AND

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instert charth name.. (2000)

    When you say chart name, do you mean the title?

    Sub insertname()
    Dim ws As Worksheet, cho As ChartObject
    Set ws = Worksheets("TABELLA_AND")
    Set cho = ws.ChartObjects(1)
    cho.Chart.HasTitle = True
    cho.Chart.ChartTitle.Text = "This is my title"
    End Sub
    Waggers
    If at first you do succeed, you've probably missed something.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instert charth name.. (2000)

    GOOD!...
    Possibkle to change the font name in Arial Bold size 8....

  4. #4
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instert charth name.. (2000)

    Add the following lines before the "End Sub" line:

    cho.Chart.ChartTitle.Characters.Font.Name = "Arial"
    cho.Chart.ChartTitle.Characters.Font.Size = 8
    Waggers
    If at first you do succeed, you've probably missed something.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Instert charth name.. (2000)

    TKS!

Posting Permissions

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