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 …

To eliminate clutter in a chart, you can display fewer axis labels or tick marks on the horizontal (category) axis by specifying the intervals at which you want categories to be labeled, or by …

To make a chart easier to understand, you can add chart titles and axis titles, to any type of chart in Excel, Outlook, PowerPoint, or Word.

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 …

Click Add Chart Element > Gridlines. Choose the axis that you want to apply the gridlines to or click More Gridline Options to open the Format Major Gridlines pane.

In a chart you create, axis labels are shown below the horizontal (category, or "X") axis, next to the vertical (value, or "Y") axis, and next to the depth axis (in a 3-D chart).

For example, in a line chart, select one of the lines in the chart, and all the data marker of that data series become selected. On the Chart Design tab, select Change Chart Type and then …

If the chart for which you want to change the plotting order displays axes, you can quickly reverse the order in which the categories or values are plotted along those axes.

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.

If a chart that you create does not display the worksheet data on the axis that you want, you can quickly change the way that data is plotted.