How to combine two graphs in excel with different x axis

Combining two charts in Excel is easier than you might think. By following these simple steps, anyone can merge charts to create a more comprehensive and visually appealing display of data. You’ll be working with data series, chart types, and the built-in tools in Excel.

Ready to dive in?

How to combine bar and line graph in excel 2010

Let’s get started.

How to Combine Two Charts in Excel

In this section, I’ll walk you through the steps to combine two charts in Excel. By the end of this tutorial, you’ll have a single chart that effectively displays multiple data sets.

Step 1: Open Your Excel Workbook

First, open the Excel workbook containing the charts you want to combine.

Ensure you have the data for both charts in your spreadsheet.

If you don’t, input the data before moving on.

Step 2: Insert the First Chart

Next, highlight the data for the first chart and insert it by going to the ‘Insert’ tab and selecting your desired chart type.

Once the chart is inserted, make sure it’s properly displaying the data you highlighted.

Step 3: Add the Second Data Set to the First Chart

Clic

how to combine two graphs in excel with different x axis

how to combine two graphs in excel with different y axis