. PLEASE FULLY READ THE SIDE-BAR BEFORE SUBMITTING A POST! SUBMISSION GUIDELINES FAQ PROBLEM SOLVED?
OPs can reply to any solutions with: This will award the user a and change the flair to SOLVED. TO APPLY CODE FORMATTING Use 4 spaces to start each line You can select code in your VBA window, press Tab, then copy and paste into your thread or comment. PROVIDE YOUR DATA! Include a or use the website to generate the reddit table markup from your spreadsheet. Recent ClippyPoint Milestones! Congratulations and thank you to these contributors Date User CP 10 1400 10 25 10 10 10 10 10 1 A community since March 11, 2009 Download the official to convert Excel cells into a reddit table.
I am trying to make a scatter plot with two series as shown in the table below. I have been able to successfully graph my data, but now I would like to use my custom labels from the 'Label' column and present them on the graph. I found this link online that shows how to solve this problem. I wish to solve this problem without using add-ons or VBA if possible.
The solution under the subheading 'Use Values from Cells (Excel 2013 and later)' seems ideal, but when I open the Format Data Labels task pane in Excel 2016 (for Mac), I don't have the option to pick 'Value from cells'. Is there anyway to do this on a Mac? Or if I get access to a Windows computer temporarily, can I make this change and then save the file as a template? Would it then work on my Mac?
As a follow-up question, what if I had two 'Labels' columns. One for each of the y-values. Would I be able to plot the text from each 'Labels' column onto the two different series?
For more flexibility, and a broader range of choices, select the Add Chart Element button on the Chart Design tab or double-click an existing Data Label.
Thanks for your help! X-value y-value1 y-value2 Label 1 15 21 alpha 2 12 14 beta 3 18 12 gamma 4 20 17 delta.