#Plot A Graph In Excel Series Are In

In the Add line to chart dialog, please check the Other values option, refer the cell containing the specified value or enter the specified value directly, and click the Ok button.I found a way. Click Kutools > Charts > Add Line to Chart to enable this feature. Select the chart you will add benchmark line for.

Add data labels and format them so that you can point to a range for the labels ('Value from cells'). Msm66 Perhaps the picture below answers your question. Re: X-Y Scatter Plot With Labels Excel for Mac. Instead, I'd always get two graphs.01:02 AM.

Plot A Graph In Excel Series Are In

The selection feeding the chart is rows 2-7 of columns B and C.Note the spacing of the 'numbers' on the x axis. X 'data' has been chosen to demonstrate the differences between a Category chart and an x-y Value chart.Note that the Category labels are in a Header column and the Y data series are in two non-header columns. 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'.A Scatter chart has two 'value' axes, and distance from the origin on both is proportional to the values in each series.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.Here's a pair of examples, using estimated Y data in the small chart shown in your post. After x-axis data had been added I could add the y values in the normal way, by clicking on the header.By the way, this works for the line plot (which I like the look of better than just points)' By the way, this works for the line plot (which I like the look of better than just points)'The Line Plot is a Category chart.

With the chart created, and selected, click the Edit Chrt References button below the chart, then go to the table and drag the small white handle right to add the second column of Y values:The second set of Y values will be immediately added to the chart. (The grey shading in part of column A is applied by Numbers to show these cells are selectedвЂ”the three unselected cells at the bottom of the table show the default 'no fill' condition of non-header cells.)Note also the horizontal spacing of the data points, and the resulting change in the slope of the lines connecting the data points.The choice of Line Chart vs Scatter Chart should depend not of the perceived aesthetics of the chart (as can be seen above, both can have a very similar style), but on which gives a truer picture of the data.For an x-y scatter chart using two series of y values and a shared series of x values, begin by selecting a single x-y pair of columns (A and B), then choose the chart type.

Plot A Graph In Excel For Mac