Actually, there is a function to add descriptive labels in Excel 2013: After you have created your XY Scatter Graph, selected X- and Y-values and clicked "Add Data Labels" (4:15 in this video), do the following: 1. Click on one point so that they are all highlighted 2. Right click on one of them (while all are highlighted), and click "Format Data Labels" 3. Under "Label Options" appearing on the right side (default), deselect "X Value" and "Y Value" 4. Select "Value From Cells" 5. Click on the button "Select Range" 6. Now, select the row containing data for your labels (for example the "items" column) 7. Voilà, you have custom labels with no coding needed.
Thank you so much!! I've been trying to figure out how to do this and no-one in my office knew the answer. But you did - and made my life so much easier! Thanks very much!
Sir, please share you mail id because I have prepared one Excel VBA programming for automatically send mail from Excel when due date reached.but email continues trigger after reach due date. I need to stop the mail in the VBA programming. Please support
Thank you Doug. Appreciate your time and effort to create this tutorial. I'm running Excel 2010, so the 7-step process posted by eivihnd is not available to me. But since I am running Excel 2010 this tutorial is a great help.
Hi Doug Many thanks for this video. I managed to add labels for the first time with them all aligned properly. I did find a couple of issues with filtering data and the code was then mis-aligned. But as I said managed it for the first time with my usual Excel jiggery pokery, thanks again.
Thanks so much for the video! This is exactly what I have been trying to do for days! Now, if I could only control the labels...meaning show and hiding based on what I am sorting...
Thanks this really helped. But my labels have very long names. So if I just want each label to have a separate symbol/colour in the graph and then have the labels to appear as legends at the side, how do I do that? I have 14 such labels.
maybe something like this ua-cam.com/video/sNQxUTs6lJA/v-deo.html can give an idea. It'll need to be combined with a change in the series name to reflect the label name.
When you add the macro in VBA, you have to do it as "insert / module", otherwise it doesn't work. At least that fixed the problem for me. Thanks for the video!
Thanks, Doug! My scatter has hundreds of points with dense concentrations in areas; the labels appear per your instructional, but are cluttered and cannot be read/presented. Any idea on how to do this, so that when you hover your mouse, the label appears ala a standard chart with auto labels?
Hi Doug H, I think it would be best if you posted the solution from eivihnd into the summary. This would have saved me a lot of time If I knew ahead of time when reading the summary, "IF YOU HAVE EXCEL 2013 just read the steps below" Actually, there is a function to add descriptive labels in Excel 2013: After you have created your XY Scatter Graph, selected X- and Y-values and clicked "Add Data Labels" (4:15 in this video), do the following: 1. Click on one point so that they are all highlighted 2. Right click on one of them (while all are highlighted), and click "Format Data Labels" 3. Under "Label Options" appearing on the right side (default), deselect "X Value" and "Y Value" 4. Select "Value From Cells" 5. Click on the button "Select Range" 6. Now, select the row containing data for your labels (for example the "items" column) 7. Voilà, you have custom labels with no coding needed. Thanks, -Jeremy
And then sum? Do you know how to automatically adjust the min and max for the x and y axis based off the min and max of the data selected? This way u only see the grid where my points are and not from 0?
***** Thanks Doug. What I was attempting to do was filter one or two items and only show those on the scatter plot. However, when I filter, it still displays the first value, with the information from the item that I selected. For example, if I filter to only display Item 2, it will plot (60,48) but still show Item 1 as the label. Hope this makes sense. I would really appreciate the help. Thanks in advance. :)
Hi Doug - great presentation and thank you very much - this was very helpful. Recently we needed to edit/change the label value. So we changed the label name in the Excel column, but the graph did not automatically update to reflect the new value. How do we do this so it's automatic and we don't have to do the whole thing over?
if you've got Excel 2013, you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html If you don't you'll have to do it over again :-(
Thank you very much. Very helpful! May be relevant to highlight that your excel file should allow macros. Sometimes it is not the case by default. Hence when saving the macro you receive a warning and you should click on "no" and choose a macro-enabled excel format. I wasted a hour because of that
Thanks Doug. This works fine for me, but I'm having issues when I include more than one data series. In this instance, only the first data series is labelled when I run the macro. Do you have any advice?
James Haythornthwaite I managed to fix this - you need to change the series number in the brackets after any reference to "SeriesCollection" in the macro to then apply the macro to that specific series. Cheers
H Doug - I have tried this macro, however it provides for an error. "xVals = Mid(xVals, InStr(InStr(xVals, ","), xVals, Mid(Left(xVals, InStr(xVals, ",") - 1), 9)))" I guess it pretty much has to do with the range that is being sellected. Please advise?
If you have Excel 2013 or later, there is a function to add descriptive labels you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html
Excel 2013 - I am trying to show results of two measurements (y is measurement one, x is measurement 2), each unit of measure is minutes spent playing video games. The x data is what my observer recorded (number of minutes each child spent playing video games, 20 children total). Y data is what observer 2 recorded (in minutes for each child spent playing video games). So - my coders viewed video tapes of areas in which children spent time playing video games. [interrater reliability] - and I want to show this in a scatterplot in which the first set of data (y) and the second set of data (x) are on the same scatter chart - but I get to the part in your video in which you manually add the chart (7:22) and my spreadsheet does not appear the same - my chart styles look completely different. Do I need to customize or add something to my access tools? Thanks - sorry if this totally confuses you - I'm totally stuck on this!
***** hi Doug! i found sth else in this case. it is called "XY chart Label". i downloaded it for free also: [ www.appspro.com/Utilities/ChartLabeler.htm] it is very useful for those people who wanna labeling a lot of different data.
Hey Doug, I currently have an excel sheet with 3 series! All the data of the 3 series are in a sheet (DataSheet), and the chart is in separate worksheet loading the data from the datasheet. First of all would I need 3 different sheets for each series so i can apply the labels and does the chart need to be on the same sheet when loading the data? Also when I apply the macro, do I apply to the entire excel file, or on the sheets or on the tabs for this scenario! Thanks in advance!
+Doug H Well the client hasnt upgraded to 2013 which doesnt allow me to work on it! Why I say I have to put each series in a seperate sheet, because the code assumes that the first column contains the label and the other 2 columns contain values to load from!
What if I told you, I just I found a way that is not shown on the Internet and is far easier than yours but requires slight manual labor and no Macro!!!
Thank you so much for sharing, Doug. But is it only me that I googled more than 3 pieces of code and none of them work or it's the same with other ppl?
Hey Doug, I have list of 20 items and need the data points to have different colors. Is there a sustainable way in the macro that I can do this, instead of manually changing the colors for each data point. Thanks.
There probably is a macro out there that can do it but I don't know VBA too well. An option is to select the first record to build the graph. Then select the 2nd record and paste it in there. The series would have a different color for the markers and subsequent series would have varying colors too.
You might want to try from the beginning to see if it works. Also this is on Excel 2010 Windows; so if you have a different setup it might have something to do with it. Unfortunately i'm a vba guy but here's something from stack overflow stackoverflow.com/questions/22735093/vba-for-excel-throws-object-variable-or-with-block-variable-not-set-when-there
Dear Doug: your video helped me a lot. Thanks. My scatter plot has different legends(e.g. It has 2 series), then the code cannot add labels, and give "Object variable or with block variable not set" error. Could you please help me on this? Thanks
Hi Doug, Great video and it helped me a lot. The problem I am facing is that there are a lot of data points on the scatter plot which make data labels overlap and it gets difficult to identify. Is there a way to remove the data labels and only show them when we hover over the data point? Thanks!
Hi Dough and thank you so much for your video. Unfortunately, the last part of the macro doesn't work and I have the following error: "Object variable or With block variable not set" Consider that I use the values that depend from a vlook formula and they come from a data download. Thank you so much and thank for your help.
Thanks a lot Doug H! It saved my dissertation thesis graphs! FYI, the macro code I took from the link you give here didn't work. I used this one instead: Sub AttachLabelsToPoints() 'Dimension variables. Dim Counter As Integer, ChartName As String, xVals As String ' Disable screen updating while the subroutine is run. Application.ScreenUpdating = False 'Store the formula for the first series in "xVals". xVals = ActiveChart.SeriesCollection(1).Formula 'Extract the range for the data from xVals. xVals = Mid(xVals, InStr(InStr(xVals, ","), xVals, _ Mid(Left(xVals, InStr(xVals, "!") - 1), 9))) xVals = Left(xVals, InStr(InStr(xVals, "!"), xVals, ",") - 1) Do While Left(xVals, 1) = "," xVals = Mid(xVals, 2) Loop 'Attach a label to each data point in the chart. For Counter = 1 To Range(xVals).Cells.Count ActiveChart.SeriesCollection(1).Points(Counter).HasDataLabel = _ True ActiveChart.SeriesCollection(1).Points(Counter).DataLabel.Text = _ Range(xVals).Cells(Counter, 1).Offset(0, -1).Value Next Counter End Sub
I have a scatter plot with 3 sets of data (series 1, series 2, series 3) but with the same set of data labels (the 'Items' column in your example). Is there a macro code for this kind of a problem?
If you have Excel 2013 or later, there is a function to add descriptive labels you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html
Soo you can have the series name display the data label value, but I had to add each point individually. In 2013, I have to add each data point individually in the select data box. Once the point is in, I add the data label, in the data label I select the series name, and x value option and in my case, I enter a new line. I use the scatter chart to make milestone across a range of dates. In 2016 it did it just fine. It pulls the series name as the data label, the x values is a date in my data and the y value is the vertical position. My extra layer is it all has to show in office 365 so our employees can access the graph on their phones.
Hi Doug, The macro returns an error whenever i run it. i am running Excel 2013. Error Code: Run-time Error '91' Object variable or with block variable not set when i try to debug it; it points out to the below line: xVals = ActiveChart.SeriesCollection(1).Formula Please advise. thanks anyways.
turns out it is coz i am running 2013. and there is a very quick fix to it there :) exde601e.blogspot.ae/2014/11/adding-labels-to-excel-scatter-charts.html
Actually, there is a function to add descriptive labels in Excel 2013:
After you have created your XY Scatter Graph, selected X- and Y-values and clicked "Add Data Labels" (4:15 in this video), do the following:
1. Click on one point so that they are all highlighted
2. Right click on one of them (while all are highlighted), and click "Format Data Labels"
3. Under "Label Options" appearing on the right side (default), deselect "X Value" and "Y Value"
4. Select "Value From Cells"
5. Click on the button "Select Range"
6. Now, select the row containing data for your labels (for example the "items" column)
7. Voilà, you have custom labels with no coding needed.
***** +eivihnd Thanks to both of you. Helped a lot!
+Doug H I have Excel for Mac 2011 so I still had to use the macro. Thanks for saving me time!
+eivihnd THANK YOU!
+eivihnd real MVP
+eivihnd oh wow so nice! Thank you sir.
YOU ROCK. I have been using excel since 1996 and have been frustrated by my inability to add labels. Thank you!
You just saved my entire day. Been spending all day trying to add data labels, but with your video it only took 5 min's. Thank you very much!!
You're welcome...glad it helped!
I searched for an hour and this is the best explanation I found. Good work! (although you could skip the first 2:20 of the video). Thank you
This was the BEST tutorial I found to figure out how to add data labels to a scatter plot chart. Doug -- Thank you so much for posting this!
Wow.... thanks for the kind words!
Thank you so much!! I've been trying to figure out how to do this and no-one in my office knew the answer. But you did - and made my life so much easier! Thanks very much!
You're welcome...thanks for the comment!
Thank you so much, Doug!
I didn't know it was not possible to label data points in a scatter chart in Excel. I was desperate...
You’re welcome!
Fixed the problem I had by 'adding data manually' just like how you said.. Thanks man!
I did same in my project with help of this video and I got award.
thank you sir
Good job man!!
Sir, please share you mail id because I have prepared one Excel VBA programming for automatically send mail from Excel when due date reached.but email continues trigger after reach due date. I need to stop the mail in the VBA programming. Please support
Thanks Rajesh Dakshanamoorthy, glad it helped!
Your video was awesome! The right pace, the right explanation (except maybe for how to create the macro itself), and the end result! Thanks so much
Glad you liked it!
Thank you Doug. Appreciate your time and effort to create this tutorial. I'm running Excel 2010, so the 7-step process posted by eivihnd is not available to me. But since I am running Excel 2010 this tutorial is a great help.
Thanks for the great tutorial. Clear and concise instructions. Saved me hours of work.
I'm SOOO excited! Thank you SO MUCH for both the pointers!
Hi Deb Phillips, glad you liked it, thanks for commenting!
Hi Doug
Many thanks for this video. I managed to add labels for the first time with them all aligned properly. I did find a couple of issues with filtering data and the code was then mis-aligned. But as I said managed it for the first time with my usual Excel jiggery pokery, thanks again.
You're welcome, glad it worked for you!
Really helpful, thank you. Worked first time in Excel 2010.
Thanks mattnicks, glad it helped!
Thanks a lot Doug. I have successfully attached labels on my excel graphs thanks to your guidance. Much appreciation!!!
Glad this helped. Thanks for the comment!
Wonderful! This helped me create a great scatter plot of the revenue and gross margin for our company's product lines. Thank you!
Thanks Michael Newman, glad it helped!
Thanks so much for the video! This is exactly what I have been trying to do for days! Now, if I could only control the labels...meaning show and hiding based on what I am sorting...
Try using the NA() function for the second table that sources the chart. See this video for some insight. ua-cam.com/video/2pF7sKR8wRQ/v-deo.html
first answer that makes sense - you are my hero! and the macro works! thank you so much!
You're welcome; thanks for the comment!
Thanks this really helped. But my labels have very long names. So if I just want each label to have a separate symbol/colour in the graph and then have the labels to appear as legends at the side, how do I do that? I have 14 such labels.
maybe something like this ua-cam.com/video/sNQxUTs6lJA/v-deo.html can give an idea. It'll need to be combined with a change in the series name to reflect the label name.
Awesome. Thank you! Your explanation was v. clear and worked first time.
thank you, but i need the non macro trick, any advice?
If you have excel versions prior 2013, the macro is it. With later version no macro needed. See ua-cam.com/video/NnoFXSFBtIg/v-deo.html
This was very helpful, thank you. When running the macro, you have to have the chart selected, or else it won't work.
Thank you very much my friend Mr. Doug H. I appreciate your video.
Hi Gangaram Choudhary...you're welcome, glad you liked!
you're a hero, Doug! Fantastic. Thanks so much.
Hi Richard Vaughan, you're welcome!
Thank You!!!! Manually added the data and it worked.
When you add the macro in VBA, you have to do it as "insert / module", otherwise it doesn't work. At least that fixed the problem for me. Thanks for the video!
You're welcome!
You did not walk through the macro section...
Developer -> Visual Basic -> Insert -> Module -> Paste code and Save. Also, you will get an error unless both X and Y values are filled in.
thank you!! this was really helpful.
Hi Matthew Morton, thanks for the comment!
Is it possible to seperate the labels even more? As Items 15, 17 and 19 are pretty close together?
Yes click on the label. The 1st click select all, a 2nd click should just be that label. Then you can move the text box around
Thanks, Doug!
My scatter has hundreds of points with dense concentrations in areas; the labels appear per your instructional, but are cluttered and cannot be read/presented. Any idea on how to do this, so that when you hover your mouse, the label appears ala a standard chart with auto labels?
Hi Doug H,
I think it would be best if you posted the solution from eivihnd into the summary. This would have saved me a lot of time If I knew ahead of time when reading the summary, "IF YOU HAVE EXCEL 2013 just read the steps below"
Actually, there is a function to add descriptive labels in Excel 2013:
After you have created your XY Scatter Graph, selected X- and Y-values and clicked "Add Data Labels" (4:15 in this video), do the following:
1. Click on one point so that they are all highlighted
2. Right click on one of them (while all are highlighted), and click "Format Data Labels"
3. Under "Label Options" appearing on the right side (default), deselect "X Value" and "Y Value"
4. Select "Value From Cells"
5. Click on the button "Select Range"
6. Now, select the row containing data for your labels (for example the "items" column)
7. Voilà, you have custom labels with no coding needed.
Thanks,
-Jeremy
And then sum? Do you know how to automatically adjust the min and max for the x and y axis based off the min and max of the data selected? This way u only see the grid where my points are and not from 0?
Hi Jeremy Lowrey, thanks for the comment!
Thank you so much I was so confused on how to create different series for scatter plots!
Thanks, Doug!!
You can right click a point on the scatter plot and click on "add data labels" then manually change the label of each point on the graph.
Hi Skid, thanks for the comment!
Great Video Doug. How can I retain the labels when I filter?
***** Thanks Doug. What I was attempting to do was filter one or two items and only show those on the scatter plot. However, when I filter, it still displays the first value, with the information from the item that I selected. For example, if I filter to only display Item 2, it will plot (60,48) but still show Item 1 as the label. Hope this makes sense. I would really appreciate the help. Thanks in advance. :)
Hi Doug - great presentation and thank you very much - this was very helpful. Recently we needed to edit/change the label value. So we changed the label name in the Excel column, but the graph did not automatically update to reflect the new value. How do we do this so it's automatic and we don't have to do the whole thing over?
if you've got Excel 2013, you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html
If you don't you'll have to do it over again :-(
Thanks so much to both Doug and eivihnd!
What a life saver. Thank you
Hi Joseph George, thanks for the kind words!
This worked great except for one thing. When I ran the macro, it also plotted a point (0,0) for the Item column heading. How do I fix that?
Excellent job ! Thank you so much for making this video.
Hi Gary Kassabian, you're welcome!
Thank you very much Doug. Great tutorial. Do you happen to know how I can loop through each series in my chart?
thanks so much. Extremely useful. Had been trying for several hrs
Hi Indra Bishop, glad you liked it, thanks for commenting!
Hi Doug - please could you post the code here, as the link no longer works. Thanks!
Thank you very much. Very helpful!
May be relevant to highlight that your excel file should allow macros. Sometimes it is not the case by default. Hence when saving the macro you receive a warning and you should click on "no" and choose a macro-enabled excel format. I wasted a hour because of that
Hi Roberto M, thanks for the comment!
Thanks Doug. This works fine for me, but I'm having issues when I include more than one data series. In this instance, only the first data series is labelled when I run the macro.
Do you have any advice?
James Haythornthwaite I managed to fix this - you need to change the series number in the brackets after any reference to "SeriesCollection" in the macro to then apply the macro to that specific series.
Cheers
James Haythornthwaite how about if I have 40 different series? How did it work for you with more than one data series? Thank you!
That's an excellent tutorial! Many thanks
H Doug - I have tried this macro, however it provides for an error.
"xVals = Mid(xVals, InStr(InStr(xVals, ","), xVals, Mid(Left(xVals, InStr(xVals, ",") - 1), 9)))"
I guess it pretty much has to do with the range that is being sellected. Please advise?
If you have Excel 2013 or later, there is a function to add descriptive labels you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html
You've saved me hours of work
Thank you Doug! that is helpful. This option should be available through "Format data labels" by clocking on any data point.
Hi Elton Mammadov, glad you liked it, thanks for commenting!
Thanks so much! I couldn't do this over my class, but now "IT WORKS". Btw, Do I need to select the data that I want to create a Scatter-plot?
Glad it worked for you. Yes, you'll need to select the data to fill out the chart, that can be done before or after you Insert>Chart
Excel 2013 - I am trying to show results of two measurements (y is measurement one, x is measurement 2), each unit of measure is minutes spent playing video games. The x data is what my observer recorded (number of minutes each child spent playing video games, 20 children total). Y data is what observer 2 recorded (in minutes for each child spent playing video games). So - my coders viewed video tapes of areas in which children spent time playing video games. [interrater reliability] - and I want to show this in a scatterplot in which the first set of data (y) and the second set of data (x) are on the same scatter chart - but I get to the part in your video in which you manually add the chart (7:22) and my spreadsheet does not appear the same - my chart styles look completely different. Do I need to customize or add something to my access tools? Thanks - sorry if this totally confuses you - I'm totally stuck on this!
Thanks, this just saved my project!
***** hi Doug. could you please share the Macro that you used for data label. i can not find that!
***** highly appreciated!
***** hi Doug! i found sth else in this case. it is called "XY chart Label". i downloaded it for free also: [ www.appspro.com/Utilities/ChartLabeler.htm] it is very useful for those people who wanna labeling a lot of different data.
All I got was a runtime error 91 : xVals Object variable or With Block not set ?
Sorry, don’t understand the comment/ question...
Thanks, it is really helpful! How to implement in power point?
Thanks Wuqing Li! You can embed this as an object in PowerPoint or copy paste as an image.
It's kind of crazy that Excel doesn't do this for you. One would think it's just common sense to have that
Oh great to know, thanks Doug!
It does! - see eivihnd above. Also works in Excel 2016. For some reason excel keeps quiet about it.
Hi Juan Ramirez, thanks for the comment!
Hey Doug, I currently have an excel sheet with 3 series!
All the data of the 3 series are in a sheet (DataSheet), and the chart is in separate worksheet loading the data from the datasheet.
First of all would I need 3 different sheets for each series so i can apply the labels and does the chart need to be on the same sheet when loading the data? Also when I apply the macro, do I apply to the entire excel file, or on the sheets or on the tabs for this scenario!
Thanks in advance!
+Doug H Well the client hasnt upgraded to 2013 which doesnt allow me to work on it!
Why I say I have to put each series in a seperate sheet, because the code assumes that the first column contains the label and the other 2 columns contain values to load from!
What if I told you, I just I found a way that is not shown on the Internet and is far easier than yours but requires slight manual labor and no Macro!!!
Thank you so much for sharing, Doug. But is it only me that I googled more than 3 pieces of code and none of them work or it's the same with other ppl?
The description field in this video has a link to the msft site so hope that helps.
How would a draw a line down the middle the perfectly split the chart? Thank you Doug H!
Really nice. thanks dude. I learnt a lot of stuff with this vid
Thanks, was driving me nuts!
Glad you liked!
Do you know if the code works with negative values? I tried doing it, but it does not seem to work
Hey Doug, I have list of 20 items and need the data points to have different colors. Is there a sustainable way in the macro that I can do this, instead of manually changing the colors for each data point. Thanks.
There probably is a macro out there that can do it but I don't know VBA too well. An option is to select the first record to build the graph. Then select the 2nd record and paste it in there. The series would have a different color for the markers and subsequent series would have varying colors too.
hitesh setpal use series in excel if you are able to group your data points in some sort of fashion
This was super helpful. thank you!
You're Welcome! Glad you found it helpful!
do you know why i would run into the error "object variable or with block variable not set"?
You might want to try from the beginning to see if it works. Also this is on Excel 2010 Windows; so if you have a different setup it might have something to do with it. Unfortunately i'm a vba guy but here's something from stack overflow stackoverflow.com/questions/22735093/vba-for-excel-throws-object-variable-or-with-block-variable-not-set-when-there
Hi, thanks for the video! How does one edit the macro so that it displays name, x-axis figure, and y-axis figure as well?
Thanks to Doug H and Thomas Paine!
You're Welcome!
Thanks so much for this! It worked perfectly!
Hi Helena Hall-Manning...you're welcome, glad you liked!
This macro isn't working on my mac! It's still labelling the plotted points with numbers rather than the country label! Any ideas?
Not sure on how this would work on Mac as this was for windows :-(
sorted it out, thanks, super helpful video
how did you fix it?
Dear Doug: your video helped me a lot. Thanks. My scatter plot has different legends(e.g. It has 2 series), then the code cannot add labels, and give "Object variable or with block variable not set" error. Could you please help me on this? Thanks
Hi Doug,
Great video and it helped me a lot. The problem I am facing is that there are a lot of data points on the scatter plot which make data labels overlap and it gets difficult to identify. Is there a way to remove the data labels and only show them when we hover over the data point?
Thanks!
Just click and drag any overlapping data points to move them apart. excel puts in a little data pointer for you.
excellent demonstration. Thank you.
Hi Ali Khan, thanks for the comment!
Hi Dough and thank you so much for your video.
Unfortunately, the last part of the macro doesn't work and I have the following error:
"Object variable or With block variable not set"
Consider that I use the values that depend from a vlook formula and they come from a data download.
Thank you so much and thank for your help.
You may try to copy paste values onto another sheet and do the charting to see if the vlookups are causing your error.
Hi,
Works great. I get the following error though. Using Excel 2010
Object variable or Block Variable not set
Can you assist please.
Thanks a lot Doug H! It saved my dissertation thesis graphs! FYI, the macro code I took from the link you give here didn't work. I used this one instead:
Sub AttachLabelsToPoints()
'Dimension variables.
Dim Counter As Integer, ChartName As String, xVals As String
' Disable screen updating while the subroutine is run.
Application.ScreenUpdating = False
'Store the formula for the first series in "xVals".
xVals = ActiveChart.SeriesCollection(1).Formula
'Extract the range for the data from xVals.
xVals = Mid(xVals, InStr(InStr(xVals, ","), xVals, _
Mid(Left(xVals, InStr(xVals, "!") - 1), 9)))
xVals = Left(xVals, InStr(InStr(xVals, "!"), xVals, ",") - 1)
Do While Left(xVals, 1) = ","
xVals = Mid(xVals, 2)
Loop
'Attach a label to each data point in the chart.
For Counter = 1 To Range(xVals).Cells.Count
ActiveChart.SeriesCollection(1).Points(Counter).HasDataLabel = _
True
ActiveChart.SeriesCollection(1).Points(Counter).DataLabel.Text = _
Range(xVals).Cells(Counter, 1).Offset(0, -1).Value
Next Counter
End Sub
Hi, thank you it worked for me this code aswell. Thank you too Doug H
It's work Very Well, thanks for you code!!!
Thank you! that was really good explaining! :D
Hi PernilleDahl, you're welcome!
Great video. Really helped me out.
Glad it helped you!
Awesome, thanks Doug!
+Wayne Barthule Glad you liked!
I have a scatter plot with 3 sets of data (series 1, series 2, series 3) but with the same set of data labels (the 'Items' column in your example). Is there a macro code for this kind of a problem?
if you have Excel 2013 or later, you don't need the macro anymore. See ua-cam.com/video/NnoFXSFBtIg/v-deo.html
Thanks a lot. This is really good!
Hi Dadawa, thanks for the comment!
Super helpful, thank you!
Glad you liked!
I also run it but got some errors here
'Store the formula for the first series in "xVals".
xVals = ActiveChart.SeriesCollection(1).Formula
If you have Excel 2013 or later, there is a function to add descriptive labels you can actually put labels without any VBA. See video at ua-cam.com/video/NnoFXSFBtIg/v-deo.html
This vid helps a lot...
Thank's so much :)
Soo you can have the series name display the data label value, but I had to add each point individually. In 2013, I have to add each data point individually in the select data box. Once the point is in, I add the data label, in the data label I select the series name, and x value option and in my case, I enter a new line. I use the scatter chart to make milestone across a range of dates. In 2016 it did it just fine. It pulls the series name as the data label, the x values is a date in my data and the y value is the vertical position. My extra layer is it all has to show in office 365 so our employees can access the graph on their phones.
Hi Maggie Badaraco, thanks for the comment!
Does this work on a macbook as well?
I'm not sure for other versions, but if you are running office 2016 for mac, it's probably going to work
Hi David, yes, I tried it today, and it works just fine. Thanks Doug!!
Loved the video...very informative.
Hi Akshay Kamath, thanks for the comment!
thank you so much! this is really helpful :)
Thanks tinypeaces, glad it helped!
Thanks a lot. Nice tutorial :)
You're welcome!
Thank you very much Sir!
You're Welcome!
thanks, very helpful video!
Thanks like piano, glad it helped!
Thank you that worked wonders.
Hi Jacob Colegrove, glad you liked it, thanks for commenting!
Hi Doug,
The macro returns an error whenever i run it.
i am running Excel 2013.
Error Code: Run-time Error '91'
Object variable or with block variable not set
when i try to debug it; it points out to the below line:
xVals = ActiveChart.SeriesCollection(1).Formula
Please advise.
thanks anyways.
turns out it is coz i am running 2013.
and there is a very quick fix to it there :)
exde601e.blogspot.ae/2014/11/adding-labels-to-excel-scatter-charts.html
Fantastic. Thanks very much
How can we do it office 2016 for mac?
I sorted that out. Thanks a lot for sharing. It was very helpful.
Hi LingFocus, thanks for the comment!
that was excellent thanks dude
Thanks! It helped a lot! :)
Hi Dalma dr. Geréné dr. Radványi...you're welcome, glad you liked!
why was first graph not correct and then you did custom?
thank you very much! very helpful :D
Thanks Ratnabhsl, glad it helped!
very helpful, thanks
Thanks, very helpful
You're welcome!
Very useful. Thanks!
Hi Alex , thanks for the comment!