How to Add a Second Y Axis to a Graph in Microsoft Excel

Adding a Second Y Axis

1. Create a spreadsheet with your data. Each data point should be contained in an individual cell with rows and columns that are labeled.

2. Select the data you want to graph. Click and drag to highlight all the data you want to graph. Be sure to include all data points and the labels.

   1. If you don't want to graph the entire spreadsheet, you can select multiple cells by holding Ctrl and clicking the cells you want to graph.

3. Click Insert. It's in the menu bar at the top of the page. This displays the Insert panel at the top.

4. Click the icon that resembles a chart type you want to create. This generates a chart based on the selected data.

   1. You can also add a second axis to a line graph or a bar graph.

5. Double-click the line you want to graph on a second axis. Clicking the line once highlights each individual data point on the line. Double-clicking it displays the "Format Data Point" menu to the right.^{[1] X Research source}

6. Click the icon that resembles a bar chart. This is the "Series Options" icon. It's at the top of the Format Data Point menu to the right.

7. Select the radio button for "Secondary Axis". It's below "Series Options" in the Format Data Point menu. This immediately displays the line on a secondary axis with the numbers on the right side.