- #1
mikekyrou
- 11
- 0
I have some data and i want to plot them on excel. I am trying to plot them but i am drilling a hole in the water. I will appreciate if anyone can help me with this. I want 3y axes and 1x.Thank you.
Last edited:
To add multiple Y axes in Excel, first click on the chart you want to add the additional axis to. Then, go to the "Layout" tab and click on "Axes". From the drop-down menu, select "Secondary Vertical Axis" and the new axis will appear on the right side of your chart.
Yes, you can customize the scale of each Y axis separately. Right-click on the axis you want to change and select "Format Axis". In the menu that appears, you can adjust the minimum and maximum values, as well as the interval and other options to customize the scale.
To change the labels on each Y axis, right-click on the axis and select "Format Axis". In the menu that appears, you can edit the axis labels and choose the source for the labels, such as the data series or custom text.
No, Excel only allows for a maximum of two Y axes. However, you can still create multiple axes by using a combination of primary and secondary axes for different data series.
Yes, you can switch the position of the Y axes in your chart. Right-click on the axis you want to move and select "Format Axis". In the menu that appears, go to the "Axis Options" tab and under "Tick Marks", choose the desired position for the axis.