Announcement

Collapse
No announcement yet.

Label data point in Scatter chart

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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

  • #2
    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

    Comment


    • #3
      Re: Label data point in Scatter chart

      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

      Comment


      • #4
        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

        Cheers
        Andy

        Comment


        • #5
          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

          Comment


          • #6
            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

            Comment


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

              Comment

              Working...
              X