How to automatically resize chart in excel

Changing the scale on an Excel graph can seem daunting, but it’s actually quite simple.

How to change x axis scale in excel

This quick guide will help you adjust the scale of your graph’s axes to better display your data. By following just a few steps, you’ll have a graph that’s easier to read and more informative for your audience.

Step by Step Tutorial: How to Change Scale on Excel Graph

Before we dive into the steps, it’s important to understand that changing the scale on an Excel graph can drastically improve the readability of your data.

Whether you’re working with a bar graph, line chart, or any other type, adjusting the scale allows you to highlight the most important parts of your data set.

Step 1: Select the graph

Click on the graph you want to change.

This will make the graph active and display the ‘Chart Tools’ in the Excel ribbon.

Once you click on the graph, you’ll notice that the border of the graph is highlighted. This indicates that the graph is selected and ready for editing.

Step 2: Open the Format Axis pane

Right-click on the axis you want to change and select ‘Format Axis’ from the context

how to edit chart size in excel

how to set up chart scale in excel