How do I add a secondary axis to a combination chart?

Add or remove a secondary axis in a chart in Excel

Table of Contents

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 add a secondary axis to a stacked column chart?

Adding Secondary Axis to Excel Charts

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.

How do you make a combo chart?

Create a combo chart with a secondary axis Click anywhere in the chart you want to change to a combo chart to show the CHART TOOLS. Click DESIGN > Change Chart Type. On the All Charts tab, choose Combo, and then pick the Clustered Column – Line on Secondary Axis chart.

How do I add another data series to an Excel chart?

Add a data series to a chart on the same worksheet

On the worksheet that contains your chart data, in the cells directly next to or below your existing source data for the chart, enter the new data series you want to add.
Click anywhere in the chart.
On the worksheet, drag the sizing handles to include the new data.

How do I add a secondary axis in Excel for Mac?

Re: secondary axis option not available on mac

Select the series you want to add a secondary axis for.
Right-click (two-finger tap) on the series.
Select “Format Data Series…”
In helper window on the right, you can choose to plot the series on primary or secondary axis.

Can I merge 2 graphs in Excel?

If you want to merge data from two graphs, rather than create a new graph from scratch, you can superimpose the two using a simple ‘copy and paste’ operation.

How do you add another data series to an Excel chart?

How do I add a secondary axis to a chart?

Combining different chart types and adding a secondary axis. To follow along, use this sample workbook. 1. Select the data you would like to use for your chart. 2. Go to the Insert tab and click Recommended Charts. 3. Click the All Charts tab and select the Combo category.

How do I combine multiple chart types into one chart?

Combining different chart types and adding a secondary axis 1 Select the data you would like to use for your chart. 2 Go to the Insert tab and click Recommended Charts. 3 Click the All Charts tab and select the Combo category. More

How do you remove a secondary axis from a graph?

To remove secondary axes immediately after you add them, click Undo on the Quick Access Toolbar, or press CTRL+Z. When the values in a chart vary widely from data series to data series, you can plot one or more data series on a secondary axis.

How do I add a second axis to a profit margin?

With the Profit margin bars selected, right-click and click on ‘Format Data Series’ In the right-pane that opens, select the Secondary Axis option. This will add a secondary axis and give you two bars. Right-click on the Profit margin bar and select ‘Change Series Chart Type’.