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 title and axis titles, to any type of chart. Axis titles are typically available for all axes that can be displayed in a chart, including depth …

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 …

When you create a chart from worksheet data that uses dates, and the dates are plotted along the horizontal (category) axis in the chart, Excel automatically changes the category axis to a date …

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).

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.

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 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.

Learn how to add a legend to a chart, retrieve a missing legend, and adjust its settings. Add, edit, or remove a chart legend in Excel.