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.

Re: Add second x axis to Excel 2016

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

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.

Flip Axis Excel Select Format AxisThe first thing we have to flip x and y axis is to select the Format Axis button. To do this,… Check Categories in reverse orderThe next thing to do is to check the Categories in reverse order. This is… Close the dialog box See More….

To add a vertical line to an Excel line chart, carry out these steps: Select your source data and make a line graph (Inset tab > Chats group > Line). Set up the data for the vertical line in this way: In one cell (E1), type the text label for the data point at which you want to draw a line exactly as it appears in your source data.

An axis on a chart or graph in Excel or Google Sheets is a horizontal or vertical line containing units of measure. The axes border the plot area of column charts, bar graphs, line graphs, and other charts. An axis displays units of measure and provides a frame of reference for the data displayed in the chart.