Display label in scatterplot excel mac os
Note that the Category labels are in a Header column and the Y data series are in two non-header columns. X 'data' has been chosen to demonstrate the differences between a Category chart and an x-y Value chart.
Here's a pair of examples, using estimated Y data in the small chart shown in your post. Scatter charts can show individual data point, with no connection from point to point, or can show the data points connected by line segments or by curves, or can show only the connecting lines, omitting the data points. The labels on the category ( x ) axis are 'categories', not 'values,' and are equally spaced with no regard to the numerical difference from one to the next (assuming they are 'numbers'.Ī Scatter chart has two 'value' axes, and distance from the origin on both is proportional to the values in each series. " 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).