How do I create a double axis chart in Excel 2010?

Add or remove a secondary axis in a chart in Excel

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

How do I create a 3 axis chart in Excel?

3 Axis Graph Excel Method: Add a Third Y-Axis

Decide on a Position for the Third Y-Axis.
Select the Data for the 3 Axis Graph in Excel.
Create Three Arrays for the 3-Axis Chart.
Create a third “axis” with a fourth data series.
Add data labels – select data label range.
Add a Text Box for the Third Axis Title.

How do I change a secondary axis to a primary axis in Excel?

Excel use primary axis in charts, to change which axis – primary or secondary – can uses for the data series, do the following:

Right-click in the second (price) data series, in the popup menu select Format Data Series… to open the Format Data Series dialog box:
Choose the Secondary Axis checkbox.

How to make two y axis in 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 . See More…

How do you create a double axis graph in Excel?

How to create this double axis graph. At the top of you toolbar select Insert, Line and click on the first line graph. Right click on the box that comes up and click on Select Data. Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart. In this case the impressions and Revenue columns.

How do I change the chart Axis in Excel?

you can go to File > Open or you can right-click the file in your file browser.

Right-click an axis. You can click either the X or Y axis since the menu you’ll access will let you change both axes at once.

Click Select Data.

You’ll see this on the left side of the window that pops up.

How do you graph multiple lines in Excel?

To plot multiple lines on an Excel graph, you will need at least two columns or rows of data. If you have only one column or row of data, add at least one other. Alternatively, open another workbook that has more than one column or row of data.