How to Combine Graphs with Different X Axis in Excel

How to Create Graphs in Excel

This is a sample dataset:

  Steps

• Select B4:C11.

• The Quick Analysis option will be displayed at the right bottom corner.
• Click it.

• Select the Charts tab and click Scatter.

• The chart based on the dataset is created.

• Click the Axis Titles to see the X and Y axis. X is the horizontal axis and Y the vertical axis.

• To change the chart title, click it.

Read More: How to Add Secondary Axis in Excel

Combine Graphs with Different X Axis in Excel

This is the dataset:

The dataset contains age, years of service, and salaries. There are two X horizontal axis. One is Age and the other Years of Service. Salary is the Y axis.

There are two graphs:

• Age VS Salary
• Years of Service VS Salary

Y is fixed but X is different.

1. Plot First Graph with X Axis in the Excel Worksheet

To plot the Age VS Salary graph:

Steps

• Go to the Insert tab.
• In Charts, click Scatter.

• Click Scatter.

• An empty graph will be displayed.
• Right-click the graph.

• Click Select Data.

• Click Add.

• Give your graph a title. Here, “Age VS Salary”.
• Select the series of your X values.

• Select the series of your Y values.
• Click OK.

2. Combine Two Graphs with Different X Axis

Steps

• Right-click the graph.

• Click Select Data.

• Click Add.

• Select the series of your X values.

• Select the series of your Y values.
• Click OK.

Excel labeled the two graphs with different colors.

Read More: How to Hide Secondary Axis in Excel Without Losing Data

How to Add a Second or Different Vertical Axis in the Excel Scatter Plot

This is the dataset:

There are a series of X values. There are also two series of Y values. There are two graphs here:

• X VS Y^2
• X VS Y^3

The horizontal axis X is the same. But, we have two different Y axis.

Steps

• Go to the Insert tab.
• In Charts, click Scatter.

• Click Scatter.

• An empty graph will be displayed.
• Right-click the graph.

• Click Select Data.

• Click Add.

• Give your graph a title. Here, “X VS Y^2”.
• Select the series of your X values.

• Select the series of your Y values.
• Click OK to create the first graph.

• To add the second vertical axis, right-click the graph.

• Click Select Data.

• Click Add.

• Select the series of your X values.

• Select the series of your Y values.
• Click OK.

The second vertical axis was added

Read More: How to Add Secondary X Axis in Excel

Download Practice Workbook

<< Go Back To Secondary Axis in Excel | Excel Charts | Learn Excel