Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 7 of 7

Thread: Label data point in Scatter chart

  1. #1
    Join Date
    24th May 2005
    Posts
    66

    Label data point in Scatter chart

    Dear Sir,

    I've got the scatter chart in sample file but I can't put the name of sale man for each data point. I'va created this chart to group sale men in each quater for efficient analysis.
    Please help!Thanks for your help.
    TQV
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Label data point in Scatter chart

    Hi,

    You can link data labels to cells in order to display the Names.
    Select the series and add data labels, display values.
    Now select each data label individually. Goto the formula bar and then click the cell to link to. This should add a formula like =Sheet1!$A$1

    Cheers
    Andy


  3. #3
    Join Date
    24th May 2005
    Posts
    66

    Re: Label data point in Scatter chart

    Quote Originally Posted by Andy Pope
    Hi,

    You can link data labels to cells in order to display the Names.
    Select the series and add data labels, display values.
    Now select each data label individually. Goto the formula bar and then click the cell to link to. This should add a formula like =Sheet1!$A$1
    Dear Andy,

    I'm sorry for my excel skill. I've follow your guide but it change the name of Chart only . E.g when I change it to =Sheet1!$A$6 the chart title change to John?
    Could you please demo it in the file and send it back to me with more clear guide?Thanks!
    TQV

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Label data point in Scatter chart

    Here is your file with the data labels linked.

    Click a data label once. Then click it again and see the formula bar.

    Check this explanation as well. It's for the chart title but the prinicple is the same.
    Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.

    Cheers
    Andy


  5. #5
    Join Date
    24th May 2005
    Posts
    66

    Re: Label data point in Scatter chart

    Dear Andy,

    I;ve got it. Thank you so much. I've spent a night with this but can't find out.Thank you once again.
    Btw, in case we have so many data points how can we do this automatically via VBA or any other ways?

    Best regards,

    TQV

    Excel Video Tutorials / Excel Dashboards Reports


  6. #6
    Join Date
    7th March 2003
    Location
    Essex, England
    Posts
    11,310

    Re: Label data point in Scatter chart

    See your other post as that now contains a link to an addin that makes the process as simple as highlighting ranges.

    Cheers
    Andy


  7. #7
    Join Date
    4th May 2006
    Location
    Indonesia
    Posts
    5

    Re: Label data point in Scatter chart

    Sub DataLabelsFromRange()
    Dim Cht As Chart
    Dim i, ptcnt As Integer
    Set Cht = ActiveSheet.ChartObjects(1).Chart
    On Error Resume Next
    Cht.SeriesCollection(1).ApplyDataLabels _
    Type:=xlDataLabelsShowValue, _
    AutoText:=True, _
    LegendKey:=False
    ptcnt = Cht.SeriesCollection(1).Points.Count
    For i = 6 To ptcnt
    Cht.SeriesCollection(1).Points(i).DataLabel.Text = _
    ActiveSheet.Range("A" & i).Value
    Next i
    End Sub

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Replies: 6
    Last Post: July 28th, 2010, 01:35
  2. Label Chart Scatter Plot Markers
    By tuesday in forum EXCEL HELP
    Replies: 2
    Last Post: June 4th, 2008, 21:37
  3. Data Label on Scatter Graph
    By Shu in forum EXCEL HELP
    Replies: 1
    Last Post: August 2nd, 2006, 13:29
  4. Replies: 5
    Last Post: April 11th, 2006, 20:33
  5. Replies: 6
    Last Post: October 22nd, 2003, 03:06

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
  •  
porno