+ Reply to Thread
Results 1 to 2 of 2

Adding a custom label to a series point

  1. #1
    den1s
    Guest

    Adding a custom label to a series point

    Hello,

    is there away to add text to a series point? I have a graph and I would
    like to add a text description of one of the points, i.e. "year one
    results".

    If possible I would like to be able to do this in Excel VBA, which
    would enable some data analysis before labelling a point.

    Any suggestions would be appreciated


  2. #2
    Jim Cone
    Guest

    Re: Adding a custom label to a series point

    With ChartObjects(1).Chart.SeriesCollection(1).Points(2)
    .HasDataLabel = True
    .DataLabel.Text = "year one results"
    End With
    --
    Jim Cone
    San Francisco, USA
    http://www.realezsites.com/bus/primitivesoftware



    "den1s"
    <[email protected]>
    wrote in message
    Hello,
    is there away to add text to a series point? I have a graph and I would
    like to add a text description of one of the points, i.e. "year one
    results".
    If possible I would like to be able to do this in Excel VBA, which
    would enable some data analysis before labelling a point.
    Any suggestions would be appreciated


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1