Heartwarming Change Chart Scale Excel

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 chart scale excel. To adjust the scale of a graph right-click on the vertical axis of the graph just where you see the values. Select the data set. This displays the Chart Tools adding the Design and Format tabs.

How to Change Scale of Axis in Chart. Select the source data and then create a chart with clicking the Insert Scatter X Y and Bubble Chart or Scatter Scatter with Smooth lines on the Insert tab. This displays the Chart Tools adding the Design and Format tabs.

Click anywhere in the chart. Click Number and then in the Category box select the number format that you want. Choose Format Axis from the Context menu.

To change the scale of other axes in a chart see Change the scale of the horizontal category axis in a chart or Change the scale of the vertical value axis in a chart. To change the scale of other axes in a chart see Change the scale of the horizontal category axis in a chart or Change the scale of the depth series axis in a chart. Select Format Axis after which youll see a pane with additional options appear on the right.

Below are the steps to add a secondary axis to the chart manually. In the Charts group click on the Insert Columns or Bar chart option. In Excel 2013 you can change the scale of axis in a chart with following steps.

Click anywhere in the chart. On the Format tab in the Current Selection group click the arrow next to the Chart Elements box and then click the axis that you want to select. In Axis Options we can set the graph bounds and units as needed.