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!!
Thanks for all the support and comments for this suggestion. We will continue to monitor this and prioritize it along with all the other suggestions. We’ve been working to make Excel more consistent between Mac and Windows, as can be seen by the updates over the past several months, which have satisfied several thousand votes on this forum (multi-thread calculation, PivotCharts, modern chart types, new functions, slicers for tables). We are listening to the suggestions, comments and votes, and we will continue to make improvements.
Steve K [MS Excel]
"Under review" since Nov 2015 and still no solution to what is clearly a necessary feature for a graphing program? Microsoft, how hard can this be?
pretty simple fix if you aren't afraid to use a macro. do not fear - try it - just follow the steps, and it will be easy.
Steps are here (I trust microsoft): https://support.microsoft.com/en-us/help/213750/how-to-use-a-macro-to-add-labels-to-data-points-in-an-xy-scatter-chart
but the steps are written for windows, so here's the MAC keyboard version. and it's even easier than described there. Get the macro into your spreadsheet first:
Step 1: copy and paste their code into clipboard. Then go to menu bar-
Tools/Macro/Visual Basic Editor. Click on "Microsoft Excel Objects" folder icon and select "This workbook". To the right is a blank area to paste the code. Then File/Close. That's it for the macro.
Step 2: build your XY scatter chart. The only condition is that your data must be set up as 3 adjacent columns. A pain, but that's the way it goes. So - your XY scatter data is in columns 2 and 3.
Step 3: click away from the chart, then click it again ("select it").
Step 4: In menu bar, select "Tools", "Macro", "Macros...", and select/run the macro (name is extracted from the first line of the code in step 1).
If all works correct, your XY data point now have labels next to them, taken from column 1.
Finally, if you edit/change the labels (not the data), you have to re-run the macro.
Yet another annoying difference between mac excel and windows. 2 years behind and counting.
REFER TO THE FOLLOWING LINK. IT WORKED FOR ME ON EXCEL FOR MAC. https://excelribbon.tips.net/T011652_Labeling_X-Y_Scatter_Plots.html
I need this too! Why has something so useful been removed? This is why people hate 'upgrading' when in reality its a downgrade in functionality.
I need this feature - hard to believe it's not available on the Mac.
You work at microsoft dude. Don't act like you care at all about what users think. You only have a paycheck due to the legacy value of products like excel. That was two years ago and you've done nothing. The world would be a better place without microsoft.
I need this feature. Why can't the features between the mac and windows Office versions be just consistent?
Rick Lawrence commented
Another basic and essential feature missing in this flawed version of Excel.
Can't believe this isn't supported! This is such a basic feature.
Please add this feature to Mac!
Zeb Jones commented
A ridiculous shortcoming. Using Google Sheets instead.
need to use this feature !!
Feature is still absent
Another user very sad to see that this is still not possible on Mac. Crazy that its been this long...
This is long overdue, please add this feature!!!!
Guillaume Dupuy commented
This is long overdue...
yes, why is is there no label function for XY scatter plots? There are macros for windows but apparently not for Mac
Vaibhav Shukla commented
Still not available and it is 2017