How to Change the X-Axis Range
- Open the Excel file with the chart you want to adjust.
- Right-click the X-axis in the chart you want to change.
- Then, click on Select Data.
- Select Edit right below the Horizontal Axis Labels tab.
- Next, click on Select Range.
Contents
How do I change the data range in an Excel 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. Then, edit the Name and Y values boxes to make any changes.
How do I change the X-axis values in a spreadsheet?
Customize the axes
- On your computer, open a spreadsheet in Google Sheets.
- Double-click the chart you want to change.
- At the right, click Customize.
- Click Vertical axis.
- Make the changes you want.
How do I change the X-axis values in Excel 365?
Right-click the category labels you want to change, and click Select Data.
- In the Horizontal (Category) Axis Labels box, click Edit.
- In the Axis label range box, enter the labels you want to use, separated by commas.
How do you create an X-axis scale in Excel?
Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Horizontal (Category) Axis.
How do I change data range?
On the Options tab, in the Data group, click Change Data Source, and then click Change Data Source. The Change PivotTable Data source dialog box is displayed. Do one of the following: To use a different Excel table or cell range, click Select a table or range, and then enter the first cell in the Table/Range text box.
How do I change the y axis values in Excel?
When you open the “Format” tab, click on the “Format Selection” and click on the axis you want to change. If you go to “Format,” “Format Axis,” and “Text Options,” you can choose for the text to be aligned vertically, horizontally, or to have a customized angle.
How do I change the horizontal axis values in Excel 2016?
Change Horizontal Axis Values in Excel 2016
- Select the Chart that you have created and navigate to the Axis you want to change.
- Right-click the axis you want to change and navigate to Select Data and the Select Data Source window will pop up, click Edit.
How do I change horizontal axis labels in Excel 2020?
Right-click the category labels to change, and click Select Data. In Horizontal (Category) Axis Labels, click Edit. In Axis label range, enter the labels you want to use, separated by commas.
How do I change the axis on Excel?
How to Switch X and Y Axis
- Right-click on the chart and choose Select Data.
- Click on the button Switch Row/Column and press OK.
How do you find the range on Excel?
Calculating Range in One Step
Imagine you have data running from cell A2 to cell A20. Type “=MAX(A2:A20)-MIN(A2:A20)” to find the range in a single step. This tells Excel to find the maximum of the data and then subtract the minimum of the data from it.
How do I change the axis label range in Excel?
From the Design tab, Data group, select Select Data. In the dialog box under Horizontal (Category) Axis Labels, click Edit. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. Click OK.