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.

How do you add axis labels in Excel 2003?

Adding a Chart Title

1. Click your chart to select it.
2. From the Chart menu, select Chart Options… The Chart Options dialog box appears.
3. Select the Titles tab.
4. In the Chart title text box, type the desired title.
5. Click OK. The title is now added to your chart.

How do I change the secondary axis in Excel?

You can change the scale used by Excel by following these steps:

1. Right-click on the axis whose scale you want to change. Excel displays a Context menu for the axis.
2. Choose Format Axis from the Context menu.
3. Make sure the Scale tab is selected.
4. Adjust the scale settings, as desired.
5. Click on OK.

How do I add a secondary axis to a scatter plot in Excel?

MrExcel MVP

1. On your scatter chart, right-click on the data series (must have at least two data series) that you want to put on the secondary Y axis.
2. Select Format Data Series.
3. Select the Axis tab.
4. Select the Secondary Axis option.
5. OK.

How do you add data labels in Excel?

Add data labels Click the chart, and then click the Chart Design tab. Click Add Chart Element and select Data Labels, and then select a location for the data label option. Note: The options will differ depending on your chart type. If you want to show your data label inside a text bubble shape, click Data Callout.

How do I create a chart in Excel 2003?

To embed a chart in a worksheet:

1. Choose View Toolbars Chart on the menu bar.
2. Select the range of cells you want to chart.
3. Click the chart type drop-down menu on the chart toolbar, then select the chart you would like to use.
4. Open the chart options dialog box: Chart Options to add a title to your chart.

How do I change the y axis in Excel?

When you open the “Format” tab, click on the “Format Selection” and click on the axis you want to change. If you go to “Format,” “Format Axis,” and “Text Options,” you can choose for the text to be aligned vertically, horizontally, or to have a customized angle.

How do you insert a secondary axis in Excel?

How to Insert a Secondary Axis in Excel Select the dataset. Click the Insert tab. In the Charts group, click the Recommended Charts option. This will open the Insert Chart dialog box. Scan the charts in the left pane and select the one that has a secondary axis. Click OK. See More….

How do you add a secondary axis title in Excel?

To add a secondary vertical axis, see Add a secondary vertical axis. Click a chart that displays a secondary vertical axis. On the Layout tab, in the Axes group, click Axes. Click Secondary Horizontal Axis, and then click the display option that you want.

How to add two axis in Excel?

1) This step applies to Word for Mac only: On the View menu, click Print Layout . 2) In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. 3) Click Add Chart Element > Axis Titles > and select between See More…

How to create a Combo Chart in Excel?

Click anywhere in the chart you want to change to a combo chart to show the CHART TOOLS.