How do I add a secondary axis in Excel 2003?

How do I add a secondary axis in Excel 2003?

or you can follow the steps below.

1. Select a point on the graph for the data set you want to put on the secondary axis.
2. Right-click and select Format Data Series…
3. Click on the Axis tab and select the Secondary axis radio button.
4. Click OK.
5. Your selected data set should now reside on the second axis of your chart.

How do I add a second Y axis in Excel?

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.

Can you have multiple Y axis in Excel?

In an Excel chart, can I have different Y-axis scales (a primary and secondary axis)? 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.

Can there be two Y axis?

When the data values in a chart vary widely from data series to data series, or when you have mixed types of data (for example, currency and percentages), you can plot one or more data series on a secondary vertical (Y) axis.

How do I add a secondary axis 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.

How do I plot multiple Y values in Excel?

Plot Multiple Y Variables Against One X Variable Help

1. Enter the data into a worksheet as shown below.
2. Select the data and the column headings.
3. Select “Correlation” from the “Statistical Tools” panel on the SPC for Excel ribbon.
4. Select the “Plot Multiple Y Variables Against One X Variable” option and then OK.