How do you add a second Y axis to a graph?

How do you add a second Y axis to a graph?

Add or remove a secondary axis in a chart in Excel

1. Select a chart to open Chart Tools.
2. Select Design > Change Chart Type.
3. Select Combo > Cluster Column – Line on Secondary Axis.
4. Select Secondary Axis for the data series you want to show.
5. Select the drop-down arrow and choose Line.
6. Select OK.

How do you change y axis to log scale?

In your XY (scatter) graph, right-click the scale of each axis and select Format axis…. In the Format Axis box, select the Axis Options tab, and then check Logarithmic scale.

How do you change the scale of the secondary axis?

You can change the scale used by Excel by following these steps:

1. Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu.
3. Make sure the Scale tab is selected.
4. Adjust the scale settings, as desired.
5. Click on OK.

How do you convert a graph to a logarithmic scale?

Select the “Scale” tab on the Format Axis window. Click the “Logarithmic Scale” check box near the bottom of the window. This changes the chart’s axis to a log scale.

How do I add a second axis to a scatter plot in Excel?

MrExcel MVP

1. On your scatter chart, right-click on the data series (must have at least two data series) that you want to put on the secondary Y axis.
2. Select Format Data Series.
3. Select the Axis tab.
4. Select the Secondary Axis option.
5. OK.

How do you change the axis scales in Excel 2016?

Changing the Axis Scale

1. Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu.
3. Make sure Axis Options is clicked at the left of the dialog box.
4. Adjust the scale settings (top of the dialog box—Minimum, Maximum, etc.)
5. Click on OK.

How do you set Y axis?

Click anywhere in the chart. This displays the Chart Tools, adding the Design, Layout, and Format tabs. On the Format tab, in the Current Selection group, click the arrow next to the Chart Elements box, and then click Vertical (Value) Axis.