How to Change the Vertical Axis (y-axis) Maximum Value, Minimum Value and Major Units in Excel

In this video, you will learn how to change the scale of the vertical axis (y-axis), the maximum value of the vertical axis (y-axis), the minimum value of the vertical axis (y-axis), major units of the vertical axis (y-axis) and minor units of the vertical axis (y-axis) in Excel Graphs or charts using format axis option. This tutorial demonstrates how to change the Y or vertical axis of excel charts to adjust or change the starts and ends at the desired number. In this way, we can control the bounds of excel charts and display values on the vertical axis. Additionally, I will also show you how to make changes in the bounds of a chart through multiple shortcuts in Excel, which is especially important since Excel has changed how to get to these configuration options over the years. You can use a similar procedure to change the scale or bound, maximum and minimum values of the bar, column, or line graph/chart in excel. For this video, I have used Microsoft excel 2016.
#changescale #verticalaxis #excelchart #teachingjunction #yaxis
Watch other RUclips video tutorials on Excel:
How to change horizontal Axis Values in Excel (Bar chart): • 🔥 How to Change Horizo...
How to change horizontal Axis Values in Excel (Line chart): • How to Change Horizont...
How to change vertical Axis Values in Excel (Bar chart): • How to Change the Vert...
How to change vertical Axis Values in Excel (Line chart): • How to Change the Vert...
Other RUclips queries:
How to change the scale of vertical axis in Excel 2016,
Change the Vertical Y Axis Start or End Point in Excel,
How to Change the Scale on an Excel Graph (Super Quick),
How To Change The Range Of The X and Y Axis In Microsoft Excel 2016,
How To Change The Position Of The Horizontal and Vertical Axis in Excel,
How to Adjust the Units in Your Excel Chart's Axes,

[@adriennegrant1411]

THANK YOU THANK YOU THANK YOU....I could not figure out how to change the vertical axis values. I struggled for 2 hours until I came across your tutorial.

[@TeachingJunction]

You're welcome!

[@mehar0786kaur]

Thank you for this video it helped me alot ❤️

[@TeachingJunction]

Glad it helped!

[@theartfantasy3477]

Thanks it helped a lot☺☺

[@TeachingJunction]

You're welcome!

[@sadiamurtaza9372]

Jzakallah its very helpful and easy to understand

[@TeachingJunction]

Glad to hear that

[@MrAlexbobalex]

This helped me! Thank you!

[@TeachingJunction]

You're welcome!

[@CodPast]

Thank you so much!

[@TeachingJunction]

Glad it helped!

[@funny__bean]

thank you very much 💓💓💓💓💓💓💓💓

[@TeachingJunction]

Most welcome

[@mr.mirabilis9021]

thank you very much!!

[@TeachingJunction]

You're welcome!

[@JyotiM-rd5wy]

Thanks buddy.. it work

[@TeachingJunction]

You're welcome!

[@jannatulmaowa9640]

Thank you 😇

[@TeachingJunction]

You're welcome 😊

[@candicechui6039]

thank you

[@TeachingJunction]

You're welcome

[@nikhilpadmane374]

Thanks bro...

[@TeachingJunction]

Welcome

[@danweir]

Thank you!

[@TeachingJunction]

You're welcome!

[@Content.333]

Nice

[@TeachingJunction]

Thanks

[@tengggg.]

is it possible to switch the order of the min and max value?
For example, I want to start from 10 going to 1 (instead of 0 to 10)

[@TeachingJunction]

If you scroll down, you will find the option of values in reverse order. Check this option. The values of y-axis will be reversed but horizontal axis will be shifted on upper side of graph

[@gdmrhotshot3731]

here cos in school i didnt know what to do

[@TeachingJunction]

How to Change Horizontal Axis Values in Excel Charts: ruclips.net/video/AbcYjFTsEoM/видео.html

[@maniksharma6010]

Ok sir ji

[@TeachingJunction]

Thanks

[@androlitoV]

doesnt exist on my histogram

[@TeachingJunction]

Thanks for your feedback. I have note down your suggestion. I will soon cover this topic in my upcoming video

[@colpireduro9255]

it does not change

[@TeachingJunction]

After changing the values click on blank cell then you will observe the change. Carefully follow the instructions as explained in the video

[@mouzam463]

Thank you

[@TeachingJunction]

You're welcome