Two chart types in one chart

In this lesson you can 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!

Two types of chart

I show you some simple example of two chart types in one chart.

First prepare some data. I have some simple table with sales data about two products.

2in1 chart data table

Next go to ribbon, click Insert and choose Column Chart.

2in1 chart ribbon

Create blank column chart.

2in1 chart blank chart

Click right on the chart and choose Select Data option. Now let's add some Series.

2in1 chart add series

Series name is =Sheet1!$B$1 and Series Values is =Sheet1!$B$2:$B$13

2in1 chart series

The same way click Edit Category and type Axis Label Range =Sheet1!$A$1:$A$13 and click OK.

2in1 chart labels

Thats how your chart looks like right now:

2in1 chart column chart

To insert Product2 Sales to chart just select Column C in the table...

2in1 chart column

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

2in1 chart pasted

To change the type of the chart, first click on the red column to select all red columns.

2in1 chart red columns

Click right on the one of them and select Change Series Chart Type.

2in1 chart change type

In th dialog box choose Line Chart and accept OK.

2in1 chart line chart

Here it is! Now there are two different types of chart! Columns and line in the one chart!

2in1 chart column and line

Little more formatting and you have your two charts ready. Isn't it simple?

Two types of chart

Download free spreadsheet.