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!!
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
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?
I need this feature quite badly. Thank you.
Format data label "Value from cell" is omitted from Mac version of Excel :-o
Get it in there ASAP :-)
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!
Any idea on when this will be available in Mac?
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 :(
really need this soon please...
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.
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.
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!
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.
linking data labels to other than the values being plotted is a really useful otpion - please DO update XL for Mac with this possibility !!!!
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?
Ory Yassur commented
Very annoying no attempt has been made to fix this simple but important issue yet!!!
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