Excel allows you to combine two chart types in one to create a more informative and visually appealing representation of your data. In this lesson, you will learn how to insert two chart types in one chart.
Do you know that you can create one chart with two different types? It is really easy!
Let me show you some simple examples of two chart types in one chart.
First, prepare some data. I have a simple table with sales data for two products.
Column Chart
Next, go to the ribbon, click Insert, and choose Column Chart.
Create a blank column chart.
Click right on the chart and choose Select Data option. Now let's add some Series.
Series name is =Sheet1!$B$1 and Series Values is =Sheet1!$B$2:$B$13
In the same way, click Edit Category and type Axis Label Range =Sheet1!$A$1:$A$13 and click OK.
Thats how your chart looks like right now:
To insert Product2 Sales into the chart just select Column C in the table.
... press Ctrl + C keyboard shortcut to copy, click on the chart and press Ctrl + V to paste the data into the chart. Now you have two columns into your chart.
To change the type of the chart, first click on the red column to select all red columns.
Click right on one of them and select Change Series Chart Type.
Column and Line chart
In the dialog box, choose Line Chart and accept OK.
Here it is! Now there are two different types of charts! Columns and lines in one chart!
A little more formatting and you have your two charts ready. Isn't it simple?
A two-chart-type combination in Excel is ready. By combining two chart types, you can represent your data in a more informative and visually appealing way, making it easier to understand and interpret. You can experiment with different chart types and combinations to find the best representation for your data.