How to Make Your Graph to the Same Scale on a Vertical & Horizontal Axis in Excel
By Ryan Menezes
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.
Ryan Menezes is a professional writer and blogger. He has a Bachelor of Science in journalism from Boston University and has written for the American Civil Liberties Union, the marketing firm InSegment and the project management service Assembla. He is also a member of Mensa and the American Parliamentary Debate Association.