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
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.
Step.2 Change from bar graph to line graph
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.
Thank you for reading until the end!