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

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 secondary axis in …

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 (time …

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

In the Change Chart Type dialog box, click a chart type that you want to use. The first box shows a list of chart type categories, and the second box shows the available chart types for each chart type …

If your chart contains chart titles (ie. the name of the chart) or axis titles (the titles shown on the x, y or z axis of a chart) and data labels (which provide further detail on a particular data point on the chart), …

Right-click the value axis labels you want to format, and then select Format Axis. Tip: If you don't see the Number section in the pane, make sure you've selected a value axis (it's usually the vertical axis on …

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.