** Excel** users often need to plot their data against multiple

**axes. This allows them to visualize data properly. In this article, we will show you how to plot a graph in**

*Y***with multiple**

*Excel***axis.**

*Y***Table of Contents**hide

## Download Practice Workbook

## 3 Handy Ways to Plot Graph in Excel with Multiple Y Axis

In this article, we will discuss how to plot graph in ** Excel **with multiple

**Y**axis. In the first two methods, we will plot graphs with two axes manually and using a command. Then, we will show how to plot a graph with

**axes.**

*3*### 1. Manually Plot Graph in Excel with Multiple Y Axis

In this method, we will manually add a secondary axis to the graph by selecting the data manually.

**Steps:**

- Firstly, select the data.
- Then, go to the
tab in the ribbon.*Insert* - Finally, from the
option, select*Charts*.*Line or Area Chart*

- Then, from the chart options, select any chart desirable for your data.
- In this case, we will choose the
chart.*Line with Markers* - Consequently, the data will be plotted.

- Then, double-click on one of the lines on the graph.
- Consequently, we will find that the data points are plotted in the primary axis.

- After that, check the
box.*Secondary Axis* - Consequently, we will find that our second axis is added to the graph.

**Read More: ****How to Plot Multiple Lines in One Graph in Excel**

### 2. Using Recommended Chart Command

In this method, we will use the * Recommended Charts* command to plot a graph with multiple vertical axes.

**Steps:**

- To begin with, select the dataset.
- Then, select the
tab from the ribbon.*Insert* - From there, hover down to the
command.*Recommended Charts*

- Consequently, the
window will appear on the screen.*Insert Chart* - Then, scroll down to select the chart that has two vertical axes.
- Finally, click
.*OK*

- As a result,
will plot our graph with two*Excel*axes.*Y*

**Read More: ****How to Plot Semi Log Graph in Excel (with Easy Steps)**

### 3. Plot Graph in Excel with Three Y Axis

In the final method, we will plot a graph with three ** Y** axes. In the process, we will format the graph in a number of ways.

**Steps:**

- To start with, choose the data.
- Then, choose the
tab in the ribbon.*Insert* - After that, from the
option, select the*Charts*.*Line or Area Chart*

- Then, from the chart options, select any chart suitable for your data.
- In this instance, we will opt for the
chart.*Line with Markers* - Therefore, a plot of the data will be created.

- Then, press
to duplicate the plotted graph.*CTRL+D*

- After that, select any one of the data plots and delete it.

- Do the same for any of the remaining two.
- Now, our data is ready to be formatted.

- After that, select the
sign beside the graph.*Plus* - From the drop-down menu, uncheck the
box.*Gridlines*

- Firstly, select the vertical axis to the left.
- Secondly, go to the
tab in the ribbon.*Format* - Finally, from the
option color the axis the same as the color of the plot.*Shape Outline*

- Then, again select the vertical axis.
- Change the weight of the vertical line.
- In our case, we set it to
**1.**pt.*5*

- Then, also change the color of the font of the axis numbers to match the color of the data plot.

- After that, select the
and delete it.*Chart Title*

- Then, click on the entire graph.
- From the available options to the right of the screen, select
.**No Fill**

- Afterward, click on the
sign to the right of the graph.*Plus* - Check the
box.*Axis Title*

- Then, format the axis title to match the color of the plot.
- After that, select the horizontal axis and reduce its minimum bounds.

- Now, go to the other chart and from there delete the plot that is modified in the previous chart.
- In our case, it will be the
data plot.*Sales*

- Then, double-click on any of the two remaining plots.
- We will find that the plot is on the primary axis.

- Make the plot on a secondary axis.

- If the two plots overlap, change the minimum and maximum bounds of any one of the plots.

- Then, select the horizontal axis.
- Turn the axis into a solid line.
- You can also change the color of the axis to a bold color.

- Then, select the horizontal axis of the
chart.*Sales* - Change the color of the text to match it with the background color.

- Finally, overlap the plots.
- Consequently, we will see that the dataset is plotted with three vertical axes.

**Read More: ****How to Make an X Y Graph in Excel (With Easy Steps)**

## How to Add Secondary X Axis in Excel

In this method, we will insert a secondary horizontal axis into our data.

**Steps:**

- To begin with, select the data.
- Then, opt for the
tab in the ribbon.*Insert* - Finally, from the
option, select the*Charts*.*Line or Area Chart*

- Then, from the chart options, select any chart desirable for your data.
- In this case, we will choose the
chart.*Line with Markers*

- Consequently,
will plot the data.**Excel** - Then, double-click on one of the lines on the graph.
- Consequently, we will find that the data points are plotted on the primary axis.
- After that, check the
box.*Secondary Axis*

- Consequently, we will find that our second axis is added in the graph.
- Then, first, click on the
sign beside the graph.*Plus* - Secondly, click the arrow sign beside the
box.*Axes* - Thirdly, check the
box.*Secondary Horizontal*

- Consequently, we will have our second
axis.*X*

**Read More: ****Plotting Row Number Instead of Value in Excel (with Easy Steps)**

## Conclusion

In this article, we have talked about how to plot graph with multiple **Y** axis in ** Excel**. After going through this article, users will have a clear understanding of how to plot data with multiple vertical and horizontal axes. This will allow them to present and interpret their data properly.

## Related Articles

**How to Plot Michaelis Menten Graph in Excel (With Easy Steps)****How to Make a Lineweaver Burk Plot in Excel (with Easy Steps)****Plotting Row Number Instead of Value in Excel (with Easy Steps)****How to Make a Graph from a Table in Excel (5 Suitable Ways)****How to Create a Chart from Selected Range of Cells in Excel**