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.
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 :
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 -
Select the columns of one X and it’s associated Y.
Click Insert and then Click Recommended Charts
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.
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.
Click on the funnel logo. A dialogue box will arrive and then click on Select Data (below this dialogue box).
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.
Give here a name of the new graph (Because we can to insert multiple).
Select X value and Y value. How? See the pictures.
Just select the column to insert the column into this . Here we inserted X value column (of course new X, not the previous X).
Do the same thing for Y. and click OK.
Now see the graph. It’s almost done. Click OK.
Now we want to rename the Y_Data. Click on Y_Data and then click edit.
Give it a name and then click OK.
After doing everything. Click OK.
This is an optional step. Click on plus sign.
Mark the elements I have marked (btw, you can be creative here).
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.