Allow for personalised data labels in XY scatter plots
In Excel 2016 for Mac there is no way to (easily) insert personalised labels to an XY scatter plot (like in the 2013 version for Windows, for instance...). In the Windows version (which I know best) there was the possibility to choose values for the labels that were not part of the XY plot itself but that option does not exist for the (2016) Mac version I can modify a few labels manually but with hundreds of point it is very complicated...
I believe this feature is of utmost relevance!!
Aldino
shared this idea
This work has been completed, so you can now use values from cells as the data labels in your charts. Just make sure you install the update to version 16.39 or greater.
To update, simply go to the Help menu and choose Check for Updates.
For more information about how to use this feature in your charts, see this article – https://support.microsoft.com/office/add-or-remove-data-labels-in-a-chart-884bf2f1-2e29-454e-8b42-f467c9f4eb2d#ID0EAACAAA=macOS
160 comments
-
Jack
commented
No, unfortunately, this update did not fix this problem. My version is fully updated and I am having a terrible time with this. I am analyzing RNA microarrays with 12,000+ data points, which I can graph, but not identify the genes associated with these points. Is there some other program that does this better? I'm in serious need!
-
Peter Li
commented
Need this ASAP.
-
Kaushal Shetty
commented
When is this available?
-
Anonymous
commented
I need this feature quite badly. Thank you.
-
Anonymous
commented
Format data label "Value from cell" is omitted from Mac version of Excel :-o
Get it in there ASAP :-) -
Anonymous
commented
Need this really urgently. I paid additional money and upgraded to office 2019 in the hope that this will be there, and its not! highly disappointed!
-
Anonymous
commented
Any idea on when this will be available in Mac?
-
Tereza
commented
I hope you guys find a solution ASAP, I'm doing a course and I'm not able to finish one of the steps because this feature doesn't exist :(
-
Anonymous
commented
really need this soon please...
-
Anonymous
commented
COME ON MICROSOFT.. REALLY?! I HAVE TO USE A MACRO TO DO THIS!! ARE WE BACK IN THE 90's!? (do appreciate you are working on it, but you gotta see why this is so annoying, especially as this is such a basic feature... that you already provide to Windows users)
-
Hazar Bard
commented
This is a pretty basic feature. It is absurd to think that this is not accesible on Mac.
-
Anonymous
commented
IF you still have access to Excel for Windows you can set up the custom data labels, save the chart then open it in the MacOS version - it displays them properly. You can format and etc but you can't change them.
Be great if Microsoft can make this as easy in the Mac version as the Windows version. They are half way there already.
-
Anon
commented
I followed the tutorial in the link but it still doesn't work! I got this error message:
"select a chart series and try again"
But it doesn't provide the medium to select the chart series
I found this link that advised to never use SELECT or SELECTION in macros, because it's slow and error-prone. And that it's better to always access the objects directly.
Could you please update the VBA procedure?
Thanks in advance!
-
Anonymous
commented
110% would love this feature added in. Got used to it on my work PC and just transitioned to a Mac for work, not realizing this feature (among others) wouldn't exist.
-
Kenn
commented
linking data labels to other than the values being plotted is a really useful otpion - please DO update XL for Mac with this possibility !!!!
-
Zoltan
commented
Appreciate this being worked on and hope to see a status update soon.
I tried the macro and it doesn't seem to get pass the dialog box requesting to select the data series. As I cannot select it before hitting ok, I selected it before starting the macro, but still couldn't get past the dialog box.
I hope I'm doing something wrong, can you please advise of the steps that should be taken?Thank you.
-
Ory Yassur
commented
+1!
-
Anonymous
commented
Very annoying no attempt has been made to fix this simple but important issue yet!!!
-
Anonymous
commented
Seriously ??? Why would this not exist. Pathetic
-
Prof. John Gallaugher
commented
Hi - does Excel 365 Mac not offer Data Labels Value from Cells? I'm teaching University students & have just noticed it's not available in my version for the Mac. Please advise. Thanks!
Prof. John Gallaugher - Boston College, Carroll School of Management