How to Make Your Graph to the Same Scale on a Vertical & Horizontal Axis in Excel

By Ryan Menezes

Edit your scales to change your graph's scope.
i Jupiterimages/Comstock/Getty Images

When you create a graph in Microsoft Excel, Excel chooses your scale automatically based on your data. For example, if a chart tracks your company's profits over several years, Excel selects a horizontal scale that includes every year in your data and a vertical scale that includes your maximum and minimum profit values. On occasion, this won't work as you need to customize your graph's scale to focus on data subsets. To set the same scale on both axes, edit the axis of one scale to better convey your point.

Click the horizontal axis label to select it.

Right-click and click "Format Axis" to open the Format Axis dialog box.

Write down the value currently in the box labeled "Specify interval unit." For example, this value may be "1."

Close the dialog bog and then write down the maximum and minimum values currently displayed on the horizontal axis. For example, the minimum value may be "0" and the maximum value may be "50."

Click a value on the vertical axis. Right-click and click "Format Axis" to open another Format Axis dialog box.

Click the option buttons labeled "Fixed" beside "Minimum, "Maximum" and "Major unit."

Enter the interval written down in Step 3 into the text box labeled "Major unit."

Type the horizontal axis's maximum and minimum values you recorded in Step 4 in the text boxes labeled "Maximum" and "Minimum."

Click "OK" to edit the graph, setting a single scale on both axes.