Create a combination chart

To emphasize different kinds of information in a chart, you can combine two or more charts. For example, you can combine a line chart that shows price data with a column chart that shows sales volumes.

A combination chart with a secondary axis

Note  To create a combination chart, you must use a 2-D chart, such as a 2-D Line, 2-D Column, Scatter, or Bubble chart.
  1. On the View menu, click Print Layout.

  2. In the chart, select a data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series.. For example, in a line chart, click one of the lines in the chart, and all the data markers A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a cell on a sheet. Data markers of the same color constitute a data series. of that data seriesA group of related data points plotted in a chart that originate from rows or columns on a single sheet. Each data series in a chart has a unique color or pattern. You can plot one or more data series in a chart. Pie charts have only one data series. become selected.

  3. On the Charts tab, under Change Series Chart Type, click a chart type, and then click the 2-D chart that you want to add to the existing chart.

    Charts tab, Change Series Chart Type group

    Note  To combine charts, you should have more than one data series.