Two Chart Types in One

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!

Two types of chart

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.

2in1 chart data table

Column Chart

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

2in1 chart ribbon

Create a 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

In 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 into the 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 one of them and select Change Series Chart Type.

2in1 chart change type

Column and Line chart

In the dialog box, choose Line Chart and accept OK.

2in1 chart line chart

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

2in1 chart column and line

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

Two types of chart

Download a free spreadsheet.