How do I change the axis scale in Excel 2010?

Changing the Axis Scale

1. Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu.
3. Make sure Axis Options is clicked at the left of the dialog box.
4. Adjust the scale settings (top of the dialog box—Minimum, Maximum, etc.)
5. Click on OK.

How do I change the scale on a graph in Excel?

How to Change the X-Axis Range

1. Open the Excel file with the chart you want to adjust.
2. Right-click the X-axis in the chart you want to change.
3. Then, click on Select Data.
4. Select Edit right below the Horizontal Axis Labels tab.
5. Next, click on Select Range.

How do you scale on axis?

Changing Axis Scale Settings

1. Select the axis.
2. Choose Format Axis from the context menu and click the Scale tab, shown below.
3. Click OK or Apply to see your changes.

How do I change the scale of a chart in Excel 2021?

To adjust the scale of a graph, right-click on the vertical axis of the graph, just where you see the values. Select ‘Format Axis’, after which you’ll see a pane with additional options appear on the right. In ‘Axis Options’, we can set the graph bounds and units as needed. But let’s go through it step by step.

How do you format axis in Excel graph?

To change the format of numbers on the value axis:

1. Right-click the value axis labels you want to format.
2. Click Format Axis.
3. In the Format Axis pane, click Number.
4. Choose the number format options you want.
5. To keep numbers linked to the worksheet cells, check the Linked to source box.

How do you change the Y axis on a graph in Excel?

Here’s how to do this:

1. Bring your cursor to the chart and click anywhere.
2. Click on the “Chart Tools” and then “Design” and “Format” tabs.
3. When you open the “Format” tab, click on the “Format Selection” and click on the axis you want to change.

How do you change the axis on a line graph in Excel?

1. Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Format tab, in the Current Selection group, click the arrow in the Chart Elements box, and then click the axis that you want to select.

How do you change the y axis values on a line graph 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 axis in an Excel chart?

How do I label the Y axis in Excel?

Click the chart, and then click the Chart Layout tab. Under Labels, click Axis Titles, point to the axis that you want to add titles to, and then click the option that you want. Select the text in the Axis Title box, and then type an axis title.

How do I change the horizontal axis in Excel?

In a chart, click the category axis that you want to change, or do the following to select the axis from a list of chart elements:

1. Click anywhere in the chart.
2. 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 you change the scale in Excel?

Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis. Choose Format Axis from the Context menu. (If there is no Format Axis choice, then you did not right-click on an axis in step 1.) Excel displays the Format Axis dialog box.

How to change axis values in Excel?

Launch Microsoft Excel and open the spreadsheet that contains the graph the values of whose X axis you want to change.

How do you change the vertical axis on Excel?

Once you have created a bar graph in Excel, you can change the vertical axis options on your bar chart using the Chart Tools. Click on the vertical axis of the bar graph. Click on the “Layout” tab under “Chart Tools.”. Click on “Format Selection.”.