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

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

Press the Format selection button. From the Series Options category, select Secondary Axis. Press the Close button. The secondary axis will appear on the right side of the chart.

Can you add two secondary axis in Excel?

Yes, in Excel 2013 and Excel 2016 you can have two axes. Start by creating a chart with just one axis. Select the data series you wish to place on a secondary axis, by clicking on the series in the chart.

How do I plot a primary and secondary axis in Excel?

Starts here1:14How to add second axis line in Excel graph – YouTubeYouTubeStart of suggested clipEnd of suggested clip58 second suggested clipIt’s that easy and you can do this for basically anything and then you can change these around clickMoreIt’s that easy and you can do this for basically anything and then you can change these around click on this one right click format data series change it to your secondary or primary.

How do I add a second horizontal axis in Excel 2007?

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 I change the horizontal axis values in Excel 2007?

Axis Options Select the chart, click the “Layout” tab of the Ribbon and choose “Horizontal (Value) Axis” from the “Current Selection” drop-down box. Click the “Format Selection” button to open the Axis Options. Change the scale of your horizontal axis from the tools at the top of the options window.

How do you add 3 y axis in Excel?

Starts here6:47How to make a chart with 3 axis in excel – YouTubeYouTube

How do you make a double line graph on Excel?

How to create this double axis graph.

1. At the top of you toolbar select Insert, Line and click on the first line graph.
2. Right click on the box that comes up and click on Select Data.
3. Click in the Chart Data Range and whilst holding CTRL highlight the data that you want to include in the chart.