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.

On a chart, click the horizontal (category) axis that you want to change, or do the following to select the axis from a list of chart elements: Click anywhere in the chart. This displays the …

When a chart displays a secondary vertical (value) axis, you can also change the scale of that axis. For more information about displaying a secondary vertical axis, see Add or remove a …

Change the text and format of category axis labels and the number format of value axis labels in your chart (graph).

The horizontal (category) axis, also known as the x axis, of a chart displays text labels instead of numeric intervals and provides fewer scaling options than are available for a vertical (value) …

In the chart, select the data series that you want to add a line to, and then click the Chart Design tab. For example, in a line chart, click one of the lines in the chart, and all the data marker of …

For example, if your chart is a 3-D chart, you will see Depth gridline options, and if your chart has a secondary horizontal axis, you will see Secondary horizontal and vertical gridline options.

Click Add Chart Element > Axis Titles, and then choose an axis title option. Type the text in the Axis Title box. To format the title, select the text in the title box, and then on the Home tab, …

Add a data series to a chart on a separate chart sheet. If your chart is on a separate worksheet, dragging might not be the best way to add a new data series. In that case, you can enter the …

To add a secondary vertical axis title, select Axis Title > Secondary Vertical, and then on the Format Axis Title pane, select Size & Properties to configure the type of vertical axis title that …