【EXCEL】How to combine bar and line graphs

Thank you for visiting. This is Masafukuro.

In this article, we will introduce how to combine a line graph and a bar graph (combined graph).

Combine bar and line graphs

Step.1

insert bar graph

Step.2

Change from bar graph to line graph

Select the table.

①Click on the “Insert” tab⇒②Click "Insert Column or Bar Chart" in the "Charts" group.

Select Clustered Column.

A bar graph will then be inserted.

Click on the bar graph to select it.

right click⇒Select Change Series Chart Type from the shortcut menu.

①Select "Combo"⇒②Change "Chart Type" of "Target value" to "Line".⇒③Click OK.

Then you can combine bar graphs and line graphs.

For related articles on "Graph" please click here.

Thank you for reading until the end!