+ Reply to Thread
Results 1 to 3 of 3

Add Data Labels, Show Series Names

Hybrid View

knightcloud Add Data Labels, Show Series... 03-17-2011, 12:56 AM
Andy Pope Re: Add Data Labels, Show... 03-17-2011, 05:02 AM
knightcloud Re: Add Data Labels, Show... 03-18-2011, 01:32 AM
  1. #1
    Registered User
    Join Date
    07-06-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2010
    Posts
    27

    Question Add Data Labels, Show Series Names

    I have a scatter plot created using three columns:
    Column A = Series Name
    Column B = X Values
    Column C = Y Values

    I would like to show the data labels above the data points showing only the series all at once and not format each series individually.

    Any suggestion would be greatly appreciated.

    Thank you!
    Last edited by knightcloud; 03-18-2011 at 03:35 AM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Add Data Labels, Show Series Names

    use this free addin to link data labels to cells.

    http://www.appspro.com/Utilities/ChartLabeler.htm
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    07-06-2010
    Location
    Philippines
    MS-Off Ver
    Excel 2007,2010
    Posts
    27

    Thumbs up Re: Add Data Labels, Show Series Names

    Thank you for your reply. This tool is a great help. I was also able to find this
    Option Explicit
    Sub LastPointLabel()
    
        Dim mySrs As series
        Dim nPts As Long
        
        For Each mySrs In ActiveChart.SeriesCollection
            With mySrs
                nPts = .Points.Count
                mySrs.Points(nPts).ApplyDataLabels _
                    Type:=xlDataLabelsShowValue, _
                    AutoText:=True, LegendKey:=False
                mySrs.Points(nPts).DataLabel.Text = mySrs.Name
            End With
        Next
    End Sub

    Since the points in my chart are of different series, I wanted to show the series name all at once if the chart is updated. I'll try to incorporate this in my code for creating XYScatter Chart.

    Thank you again for your help.

+ 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