# How can I use Excel to create a graph with two vertical axes?

##### 1 Answer

Let's assume that you are asked to plot on a graph the average temperature and average rainfall for four cities.

The data are:

Bangkok = 27.0 °C, 9.9 mm; Phuket = 26.0 °C, 41.1 mm; Pattaya = 36.5 °C. 9.8 mm; Chiang Mai = 22.0, 5.3 mm

Here's how I do it using Excel 2010 for Windows. You may have to modify for your version.

First, watch Mr. Pauller's video on how to use Excel for linear regression.

Enter your data into Columns A, B, and C of the Excel spreadsheet.

Highlight the data from A1…C5. Click on **Insert Charts**.

Click the small triangle under **Line**. Select the first option in the second row (the graph with lines and points).

You should get a graph that looks like this.

The one vertical axis is used for both temperature and rainfall.

We want to add a second vertical axis, so that one axis represents temperature and the other represents rainfall.

**How to add a secondary vertical axis**

**1.** Click on a point in the Rainfall graph

This displays the

Chart Tools, adding theDesign,Layout, andFormattabs.

**2.** On the **Format tab**, in the **Current Selection** group, click **Format Selection**.

This displays the

Format Data Pointdialogue.On the

Series Optionstab, clickSecondary Axisand then clickClose.A secondary vertical axis is displayed in the chart.

This is your graph with two axes.

Now you can use the usual tools of Excel to edit the appearance of the graph by adding titles for the chart and axes, changing the axis options, etc.

Here is one possibility.