Recommendation Change Scale In Excel Graph

Or you can manually adjust the axis scales.

Change scale in excel graph. On the Design tab in the Data group click Switch RowColumn. A beautiful line graph but the scale of the X axis is wrong. Right-click on the Profit margin bar and select Change Series Chart Type.

Select the axis that we want to edit by left-clicking on the axis. Tick marks at 30 second intervals but instead it just shows 1 2 3 etc. When the values that are plotted in the chart cover a very large range you can also change the value axis to a logarithmic scale also known as log scale.

Change the way that data is plotted Click anywhere in the chart that contains the data series that you want to plot on different axes. In a chart sheet or an embedded chart click the value y axis that you want to change. Right-click on the axis whose scale you want to change.

A quick how-to on changing the scale of your graph. In our example we will change the minimum scale to 15000 and maximum scale to 55000 on the vertical axis. With the Profit margin bars selected right-click and click on Format Data Series In the right-pane that opens select the Secondary Axis option.

By default Microsoft Excel determines the minimum and maximum scale values of the value y axis in a chart. If we want to change the axis scale we should. This will add a secondary axis and give you two bars.

Note The Selected Axis command is. You can however customize the scale to better meet your needs. Click Format Axis in the dialog box.