Cool Excel Chart Change Scale
On a chart click the horizontal category axis that you want to change or do the following to select the axis from a list of chart elements.
Excel chart change scale. How to Adjust the Scale of a Graph To adjust the scale of a graph right-click on the vertical axis of the graph just where you see the values. In an Excel chart can I have different Y-axis scales a primary and secondary axis. To change how Excel scales the category axis select the chart and then choose Chart Tools.
From the Format tab Current Selection Group check you have the correct data. Right click the axis you want to change select Format Axis from context menu. 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.
Click Format Axis in the dialog box. By default Microsoft Excel determines the minimum and maximum scale values of the value y axis in a chart. Right-click on the axis whose scale you want to change.
In Excel 2013 you can change the scale of axis in a chart with following steps. Discover how to change the scale used on the y axis of an Excel chart and customise the gridlines to show major and minor unitsTOPIC TIME CODES SHOW NOTE. Visit us at httpwwwdeerswoodcoukThis netcast shows how to have two data series with different scales on one Excel chart.
Select the axis that we want to edit by left-clicking on the axis. Point where the horizontal axis crosses the vertical axis To change the scale of other axes in a chart see Change the scale of the vertical value axis in a chart or Change the scale of the depth series axis in a chart. Note The Selected Axis command is.
Excel displays a Context menu for the axis. Click anywhere in the chart. You can however customize the scale to better meet your needs.