Feedback by UserVoice

 

How can we improve Excel for Mac?

← Excel for Mac

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!!

303 votes
Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close

We’ll send you updates on this idea

Aldino shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded  · 

Good news. We are working on this. In the meantime, we’ve published a macro that makes it easy to set personalized data labels for charts in Excel for Mac. Please see this article for instructions on adding it to your personal macro workbook so that you can control the labels for your charts.

https://support.office.com/article/set-custom-data-labels-in-a-chart-272a4658-0dab-4fe1-9248-6463207fe595

Show previous admin responses (2)

155 comments

Sign in
(thinking…)
Sign in with: Facebook Google
Forgot password?
Create a password
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Anonymous commented  ·   ·  Flag as inappropriate

    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!

  • Tereza commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    This is a pretty basic feature. It is absurd to think that this is not accesible on Mac.

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

    https://answers.microsoft.com/en-us/msoffice/forum/all/color-points-in-chart-using-vba/7dfc35ba-0636-4419-b812-2f1994fc4d24

    Could you please update the VBA procedure?

    Thanks in advance!

  • Anonymous commented  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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  ·   ·  Flag as inappropriate

    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.

  • Anonymous commented  ·   ·  Flag as inappropriate

    Very annoying no attempt has been made to fix this simple but important issue yet!!!

  • Prof. John Gallaugher commented  ·   ·  Flag as inappropriate

    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

  • AB commented  ·   ·  Flag as inappropriate

    ^ This. Fix this. Surely it wouldn't take much? Please!

  • AB commented  ·   ·  Flag as inappropriate

    Pretty basic stuff... come on, folks. Easy fix, yes? Surprised me yesterday when I couldn't reproduce a basic table on my laptop.

← Previous 1 3 4 5 6 7 8

Excel for Mac: Charting, Mapping and Visualizations

Categories

Feedback and Knowledge Base

(thinking…)