" By the way, this works for the line plot (which I like the look of better than just points)" After x-axis data had been added I could add the y values in the normal way, by clicking on the header.īy the way, this works for the line plot (which I like the look of better than just points) Clicking the header in this instance did not select the entire column - I had to click and drag. Next, I added new x-axis data by using mouse pointer to select the data values in my column containing x data. The large screen capture below shows this.įirst I highlighted every cell (command + a after placing the cursor in this field) and then pressed the delete button to delete all x-axis data. In the Label References field you will see those cells that make the x-axis. In the inspector (with the chart selected) I selected the Axis tab and then Category ( x ). Part of what was confusing was that I was expecting the first selected column to be the x-axis and the second column selected to be the y-axis - when adding data to the chart (what the help file indicates to do). If you have entered custom label text but want to display the data label entries that are linked to worksheet values again, you can click Reset Label Text.I found a way. To adjust the label position to better present the additional text, select the option that you want under Label Position. To change the separator between the data label entries, select the separator that you want to use or type a custom separator in the Separator box. For example, in a pie chart, data labels can contain percentages and leader lines. The label options that are available depend on the chart type of your chart. You can also right-click the selected label or labels on the chart, and then click Format Data Label or Format Data Labels.Ĭlick Label Options if it's not selected, and then under Label Contains, select the check box for the label entries that you want to add. On the Format tab, in the Current Selection group, click Format Selection. This displays the Chart Tools, adding the Design, Layout, and Format tabs. To display additional label entries for a single data point, click the data label in the data point that you want to change, and then click the data label again. To display additional label entries for all data points of a series, click a data label one time to select all data labels of the data series. Select the existing text and then type the replacement text. The cell values will now display as data labels in your chart.Ĭhange the text displayed in the data labelsĬlick the data label with the text to change and then click it again, so that it's the only data label selected. When you do that, the selected range will appear in the Data Label Range dialog box. When the Data Label Range dialog box appears, go back to the spreadsheet and select the range for which you want the cell values to display as data labels. You can use cell values as data labels for your chart.Ĭlick Label Options and under Label Contains, select the Values From Cells checkbox.
#Add data labels scatter chart excel 2011 mac series
Right-click the data series or data label to display more data for, and then click Format Data Labels.Ĭlick Label Options and under Label Contains, pick the options you want. Tip: If the text inside the data labels is too hard to read, resize the data labels by clicking them, and then dragging them to the size you want.