If you are losing your mind trying to get the X-axis to start at 0: Chances are you are using a line chart, which lists category numbers on the X-axis, starting with '1' for 'category 1'. Use a scatter chart instead. It uses values from data fields on the X-axis. Scatter chart is available in the variant with lines and no markers. That makes it look like a 'normal' line diagram.
Hi, the bounds of my Axis option are automatic and I can not reset to a value that is wanted. Could you please guide me on how to define manually the amount of the axis bounds? Many thanks
You can edit the values of the axis manually by Right clicking on the axis Click select data Add series Go to edit Manually enter values separated by commas
For me its not showing up because I am using a line plot, I can’t change it to scatter because that will mess it up. Is there any way to change it in a line plot?
I have to use a chart that shows the trendline so that two points will hit the line and give me the slope. That’s not the problem but for some reason my highlighted y values will not sit on the y axis like they are supposed to, so basically my y & x values are flip flopped for no reason. I’ve had the correct data before but for some reason it’s messing me up now 😭
sir I have confusion that someone say that in Excel job has no scope and progress .Is it true sir. Can I not progress with Excel skill with advance knowledge.please sir clear my confusion and reply me .
It depends on A LOT - the main thing is that many many jobs require knowledge of Excel and, if you are very good in Excel, this can help you get ahead in your job. However, few people advance in their job by only knowing Excel. Excel is merely a tool and it always helps to know how to user your tools well. I can't give you a more specific answer because I don't know the specifics of your situation.
THANK YOU!!! Haven't used my MBA in years and I forgot the easiest things in excel. Trying to run county stats for the AZ Election in Maricopa County...TH-cam going to probably block that since I think they know I found an anomaly but what it means I do not know yet.
VBA/Macros Course (40% Discount): www.teachexcel.com/vba-course-update.php?src=yt_pinned_comment_r5RwETjFZNI
Thanks so much. Nothing to it once somebody shows you how!!
If you are losing your mind trying to get the X-axis to start at 0:
Chances are you are using a line chart, which lists category numbers on the X-axis, starting with '1' for 'category 1'.
Use a scatter chart instead.
It uses values from data fields on the X-axis.
Scatter chart is available in the variant with lines and no markers. That makes it look like a 'normal' line diagram.
You literally just saved my life. And my computer's.
YOU JUST SAVED MY LIFE THANK YOU
You saved 2 lifes including mines, A TRUE HERO!
3 lives saved
4 lives saved brought
Straight to the point; exactly what I needed, thank you!
Thanks! This helps my assignment!
Thank you so much for this very helpful explanation. I appreciate you!
Hi, the bounds of my Axis option are automatic and I can not reset to a value that is wanted. Could you please guide me on how to define manually the amount of the axis bounds? Many thanks
You can edit the values of the axis manually by
Right clicking on the axis
Click select data
Add series
Go to edit
Manually enter values separated by commas
Thank you so much for the way you explained things!
You are very welcome Heather! I'm glad I could help :))
Thank you so much for posting this video! This is exactly what I needed. 😊
Thank you! Great video!
This is a very good video!
Thanks a million for this tip
How do I start my 0 higher up on the vertical ?
For me its not showing up because I am using a line plot, I can’t change it to scatter because that will mess it up. Is there any way to change it in a line plot?
Is there a way to flip the values? So the minimum is higher than the maximum? Ex - min of 40 and maximum of 1?
Yes on the format axis (axis options), you stroll down and click values in reverse order.
how do you do this on mac?
You can tell mans is so damn frustrated with Excel like the rest of us lmao
What if need to adjust x-axis. The Bounds are not appearing on my X axis
Excellent! Many thanks.
Is there a way to do a broken axis? like the zig zag to skip a bunch of values that are not used on the scale?
I also want to know.
How to reduce when you have text on y axis
Thanks man, i was on my last minute edit for my final year project 😵
mine doesnt have bounds option!
Perfect. Thanks.
Unable to do this same for X-axis. Help me out please!
IS IT POSSIBLE ON X AXIS
yes
thank you sir. almost cried when i got stressed out about not knowing how to change the value from zero
I have to use a chart that shows the trendline so that two points will hit the line and give me the slope. That’s not the problem but for some reason my highlighted y values will not sit on the y axis like they are supposed to, so basically my y & x values are flip flopped for no reason. I’ve had the correct data before but for some reason it’s messing me up now 😭
love u with thanks!!
Very helpful, thank you
My y-axis is a category, not a value so you can't change it, but I need it to start from zero, Idk what to do.
Hello, thank you.
Awesome and very helpful video sir.
Glad to help)
Thank you very much
I love your voice
I love you man
Hi.. thanks.. good quick tips to manipulate the min/max of a chart axis. Thumbs up!
Cheers)
sir I have confusion that someone say that in Excel job has no scope and progress .Is it true sir. Can I not progress with Excel skill with advance knowledge.please sir clear my confusion and reply me .
It depends on A LOT - the main thing is that many many jobs require knowledge of Excel and, if you are very good in Excel, this can help you get ahead in your job. However, few people advance in their job by only knowing Excel. Excel is merely a tool and it always helps to know how to user your tools well. I can't give you a more specific answer because I don't know the specifics of your situation.
@@TeachExcel thank you
hell sir how to draw cross section in excel 2019
Thanks
thanks!
Simple methods
Thank you
THANK YOU!!! Haven't used my MBA in years and I forgot the easiest things in excel. Trying to run county stats for the AZ Election in Maricopa County...TH-cam going to probably block that since I think they know I found an anomaly but what it means I do not know yet.
this isn't what Excel for Mac looks like. do yo uhave any ideas for Excel on a Mac?
🤬
Thank you so much