183 votes40 comments · Excel for Mac » Charting, Mapping and Visualizations · Flag idea as inappropriate… · Admin →
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]drew commented
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.