MS Excel : Use multiple X axis in a single Graph

Microsoft Excel is a very popular software for instant graph drawing using data table. To draw a graph, simply we need one X axis and one(usually) Y axis. We also can use multiple Y axis for same X axis. It’s very easy. But sometimes we need to use multiple X axis for same Y axis. It’s not so easy and there are not enough sources in online to learn this. Btw, I mean this type of graph.

Image for post
Image for post
There is two X axis and one Y axis

I also faced difficulties while doing this, then a friend helped me to do this. I’m writing this process here for future use (as source is not so available).
To use multiple X axis follow the steps :

Step 1:

Create/Open an Excel file and make data table. If you are new in that, please learn this thing first (Google it). Whatever, I have created a data table(not actually table, it’s a dataset), which looks like this -

Image for post
Image for post
Datasets are made in MS Excel

Step 2:

Select the columns of one X and it’s associated Y.

Image for post
Image for post

Step 3:

Click Insert and then Click Recommended Charts

Image for post
Image for post

Step 4:

Select this type of chart which I have selected (You are first timer, so don’t be too much creative for now). Then click OK.

Image for post
Image for post

Step 5:

Now you can see a graph of one X and one Y. I will make a color change for better view. I am going into a dark theme.

Image for post
Image for post
Image for post
Image for post

Step 6:

Click on the funnel logo. A dialogue box will arrive and then click on Select Data (below this dialogue box).

Image for post
Image for post

Step 7:

Here we go to our main part. Here we can add more data in this graph. And here Y_Data is the graph which we firstly created (I don’t know why it is named like this, but we will rename it later). Now click on Add.

Image for post
Image for post

Step 8:

Give here a name of the new graph (Because we can to insert multiple).

Image for post
Image for post

Select X value and Y value. How? See the pictures.

Image for post
Image for post

Just select the column to insert the column into this . Here we inserted X value column (of course new X, not the previous X).

Image for post
Image for post

Do the same thing for Y. and click OK.

Image for post
Image for post
Image for post
Image for post

Now see the graph. It’s almost done. Click OK.

Image for post
Image for post

Step 9:

Now we want to rename the Y_Data. Click on Y_Data and then click edit.

Image for post
Image for post

Give it a name and then click OK.

Image for post
Image for post

After doing everything. Click OK.

Image for post
Image for post

Step 10:

This is an optional step. Click on plus sign.

Image for post
Image for post

Mark the elements I have marked (btw, you can be creative here).

Image for post
Image for post

Okay, finally you are done. You can insert many many columns (not matter X or Y) here. Make experiments to be skilled for these things.

Thank you so much for reading this article.

CS Undergrad | BUET

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store