How do you select X and Y values on a graph in Excel?
You want one set of values to be on the X-axis, but it’s still on the Y-axis, even if you click Design >> Data >> Switch Row/Column….Set X and Y axes
- Click inside the table.
- Navigate to Insert >> Charts >> Insert Scatter (X, Y) or Bubble Chart.
- Choose Scatter with Straight Lines.
How do you choose X and y-axis on a graph?
The Axes. The independent variable belongs on the x-axis (horizontal line) of the graph and the dependent variable belongs on the y-axis (vertical line). The x and y axes cross at a point referred to as the origin, where the coordinates are (0,0).
How do I select Axis in Excel graph?
Please try the following steps:
- On the line chart, select the x-axis, then right click and choose Select Data.
- On the Select Data Source window, select stress from Legend entries part, then click the minus sign below it.
- Click the text box next to Horizontal axis labels, then select the data from column A, click OK.
How do you select two sets of data in Excel?
To select a range, select a cell, then with the left mouse button pressed, drag over the other cells. Or use the Shift + arrow keys to select the range. To select non-adjacent cells and cell ranges, hold Ctrl and select the cells.
How do I select two columns in an Excel graph?
Position the cursor in the column header of the first column, and click and hold while you drag to select adjacent columns. Position the cursor in the row header of the first row, and click and hold while you drag to select adjacent rows.
How do I select certain columns in an Excel graph?
How do I select data in an Excel graph?
Follow these steps:
- On the Insert tab, select the chart type you want.
- On the Chart Design tab, select Select Data.
- Click in the Chart data range box, and then select the data in your worksheet.
How do you select data series in Excel chart?
Click on the chart. On the ribbon, click Chart Design and then click Select Data. This selects the data range of the chart and displays the Select Data Source dialog box. To edit a legend series, in the Legend entries (series) box, click the series you want to change.
How do I select multiple series in Excel chart?
Select Series Data: Right click the chart and choose Select Data from the pop-up menu, or click Select Data on the ribbon. As before, click Add, and the Edit Series dialog pops up. There are spaces for series name and Y values. Fill in entries for series name and Y values, and the chart shows two series.
How do you select data in a series?
Right-click your chart, and then choose Select Data. In the Legend Entries (Series) box, click the series you want to change. Click Edit, make your changes, and click OK.
How do you select all series in Excel chart?
How do I select specific data in excel?
On the Home tab, click Find & Select > Go To (in the Editing group). Keyboard shortcut: Press CTRL+G. Click Special.