How to combine different data in one chart

Excel 365 2013
To make your data more information, you can combine different chars in many ways.

   1.   Combine a Bubble chart with an Area chart:

The Competition Chart Excel 2016

See Bubble and Area chart for more details.

   2.   Show several axes and chart types in one chart:

Chart with several axis in Excel 2016 Chart with several axis in Excel 2016

See Using two axes in the one chart for more details.

   3.   Combine two different data series with common horizontal and different vertical values:

Several Charts in one in Excel 2016 Several Charts in one in Excel 2013

See Combining several charts into one chart in Excel 2016 and Combining several charts into one chart in Excel for Microsoft 365 for more details.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.

See Also

Using two axes in the one chart

Using two axes in the one chart

Sometimes you want to show several axes in one chart to demonstrate each data series with different formatting and with different axis in one chart.
How to make your data changes in the chart more informative

How to make your data changes in the chart more informative

Simple line and bar charts often attract little or no interest in the audience. Still, Excel allows you to attract attention to your data by emphasizing change direction, difference, or period.
Combining several charts into one chart

Combining several charts into one chart

If you want to combine more than two different data series with common horizontal and different vertical values, you could not just add another axis to the chart. You need to combine several charts into one chart.