Forum Discussion

Copper Contributor

Apr 04, 2020

X-Y Scatter Plot With Labels Excel for Mac

Greetings. Excel for Mac doesn't seem to support the most basic scatter plot function - creating an X-Y plot with data labels like in the simplistic example attached. Can someone please point me towa...

Charting

Excel on Mac

Riny_van_Eekelen

Platinum Contributor

Feb 13, 2021

msm66 Perhaps the picture below answers your question. Add data labels and format them so that you can point to a range for the labels ("Value from cells"). This is standard functionality in Excel for the Mac as far as I know.

Now, this picture does not show the same label names as the picture accompanying the original post, but to me it seems correct that coordinates (1,1) = a, (2,4) = b and (1,2) = c.

albertkirby

Copper Contributor

Mar 04, 2021

this option is not available on my version. how is that possible?

Riny_van_Eekelen
Platinum Contributor
Mar 06, 2021
albertkirby Just some extra info. Found this article (link below), explaining that this feature was added to Excel for Mac in July 2020, version 16.39
https://excel.uservoice.com/forums/304933-excel-for-mac/suggestions/10819620-allow-for-personalised-data-labels-in-xy-scatter-p
- Chris_Meyerhoff
  Copper Contributor
  Jun 23, 2023
  Have the same issue: "Values from Cells" not an option listed in Excel for Mac. It's a 2018 version, but still to not be able to plat simple X-Y chart with text labels is kind of ridiculous. Riny_van_Eekelen
Riny_van_Eekelen
Platinum Contributor
Mar 04, 2021
albertkirby What version are you on?