How to combine different data in one chart

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

   1.   Combine a Bubble chart with an Area chart

Bubble and area charts in Excel 365

See Bubble and Area chart for more details.

   2.   Show several axes and chart types in one chart

Chart with several axis in Excel 365
Chart with several axis in Excel 365

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 365

See Combining several charts into one chart for more details.

See also this tip in French: Comment combiner les données différentes dans un graphique.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.

How to combine different data in one chart

How to combine different data in one chart

To make your data more information, you can combine different chars in many ways.
How to combine different data in one chart

How to combine different data in one chart

To make your data more information, you can combine different chars in many ways.
Bubble chart

Bubble chart

The most popular charts display data in one (as a pie chart, radar, or spider chart) or two dimensions (any type of line chart or scatter plot). If you need to display data in three dimensions, you can use 3D charts or bubble charts.