Connect with us

Guide

How to Combine Two Graphs in Microsoft Excel

Published

You can improve the display of the two different kinds of data by choosing chart types that are complementary to one another, such as a column chart and a line graph.

This type of combination chart is typically used for displaying data such as average monthly temperature and precipitation together, manufacturing data such as units produced and the cost of production, or monthly sales volume and average monthly sale price. Other common uses for this type of chart include displaying data such as units produced and the cost of production. Excel instructions for combining two graphs are provided below.

Read Also: How to Add Alt Text in Microsoft Excel

How to Combine Two Graphs in Microsoft Excel

You will need to begin by constructing a basic column chart as a first step.

1. Enter the data that can be seen in the image into the range of cells that starts at A1 and goes up to C14.

How to Combine Two Graphs in Microsoft Excel

2. You will need to select the information that will be included in the chart, which will cover the range from cell A2 all the way up to cell C14.

How to Combine Two Graphs in Microsoft Excel

3. Check that the Insert tab is selected on the ribbon and then proceed.

How to Combine Two Graphs in Microsoft Excel

Trending