Excel Scatter Plot With Labels Mac. I have 3 columns of data. There seems to be an explanation for it with windows but none for Mac users.
And select your range of labels you want on the points. A tutorial showing how to make and format a scatter plot using Mac 2011 Excel. Select the data you use and click Insert.
Right click on a chart dot and left click on Add Data Labels.
Tick off the Data Labels box click the little black arrow next to it and then click More Options On the Format Data Labels pane switch to the Label Options tab the last one and configure your data labels. Click the disclosure arrow next to Value Labels select the checkbox next to Values then click the Value Data Format pop-up menu and choose an option. Tick off the Data Labels box click the little black arrow next to it and then click More Options On the Format Data Labels pane switch to the Label Options tab the last one and configure your data labels. Display text labels in X-axis of scatter chart Actually there is no way that can display text labels in the X-axis of scatter chart in Excel but we can create a line chart and make it look like a scatter chart.
