I'm unable to change bounds for the x-axis as you are showing @3:23. I don't see min and max in axis options. I just see axis type, vertical axis crosses, and axis position. How to I adjust the bounds?
Great video! any chance that you could publish a video about how to create a graph with 3 different x-axis (1st: 0-10, 2nd: 0-1 and 3rd: 0-1000) with 1 same y-axis (0-1) please?
That really nice ... I was looking to construct tertiary axis for long. Than you very much. One thing where I got stuck is at 3:07 where you changed the min and max bounds of axis. Excel 2013 is not showing the option "bounds" here. What to do? please guide.
Why isn’t this working for me, when I change the minimum and maximum it all goes wrong, the grey line (on your video for me) is further to the left than the other graph so expanding it doesn’t help and shrinking it means an overlap in the axis titles.
Any suggestions for changing the Bound value in Excel 365. There is no minimum or maximum, so I can't alter the position of the axis in the second chart.
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
Any ideas as to why Excel wont let me group the two charts together at the end? The functionality appears to be disabled for charts but is available for objects.
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
You can still get this to work. Go to axis options and change the minimum bound to a negative number. Then change the 'vertical axis crosses' to 'axis value' and change the axis value to match the minimum bound.
We Need more people like you. You are born a teacher. Thank you
never thought in my lifetime i would be looking for a video : how to make 3 axis in excel...lmao thank you
The BEST tutorial! straight to the point no lengthy talking
You're a hero, Karina!
Excellent Karina, You just made my day
Very well delivered; not rushed and carefully sequenced steps. Thanks Karina! (I hope you will also share some day more axes!!!
This is a lifesaver! Thank you!
Hope you learnt something new and interesting. Thanks for watching and please Like, Comment and Subscribe.
mam, u solve my 5 month problem, thnk u
Thanks Karina for the step-by-step explanation
This is seriously brilliant! Thank you 😃
Thank you for going straight to the point!!
I appreciate your knowledge
simple solution for complicated data, this works for me, thank you
Thank you so much for your course
i don't know u Karina, but I love you 😍 thank u very much for this!
I'm unable to change bounds for the x-axis as you are showing @3:23. I don't see min and max in axis options. I just see axis type, vertical axis crosses, and axis position. How to I adjust the bounds?
Exactly.
The bound maximum/minimum options are not there.
thanks sister, great help for my thesis charts
Thank You for your efforts. Well explained
Lots of respect! Thank you!
Very productive.
Great job. Thanks.
REALLY HELPING ME SO MUCH THX!!!
Great video! any chance that you could publish a video about how to create a graph with 3 different x-axis (1st: 0-10, 2nd: 0-1 and 3rd: 0-1000) with 1 same y-axis (0-1) please?
Ya ya..quite genius and genuine
So so helpful and thank you! You are a great teacher Karina!
That really nice ... I was looking to construct tertiary axis for long. Than you very much. One thing where I got stuck is at 3:07 where you changed the min and max bounds of axis. Excel 2013 is not showing the option "bounds" here. What to do? please guide.
I had the same problem
So I am. What did you do?
Did you select the a scatter plot chart? If you select a normal line chart option it might not show the bounds.
Awesome...... Awesome...... Just awesome👌
superb tip. many thanks
Great tip 👍🏻.. thanks for sharing
Absolutely brilliant. Insert gif of exploding head here:
Thanks much, this is very helpful
Why isn’t this working for me, when I change the minimum and maximum it all goes wrong, the grey line (on your video for me) is further to the left than the other graph so expanding it doesn’t help and shrinking it means an overlap in the axis titles.
same thing with me
When you set a minimum, scroll down to intersection of vertical axis, then chose the minimum you set, it should work
@@asmaelaouina7047 Thank you very much. This works!
Thank you so much!
Why my x axis option after I change it to the text, it cannot show any number pan in format x axis, but you can 3:09
You could try using a scatter chart instead of a line chart
This is art
Any suggestions for changing the Bound value in Excel 365. There is no minimum or maximum, so I can't alter the position of the axis in the second chart.
Same prblm
GOOD! SIMPLE IS BEST!!!
thank you so much for the tutorial, really help me
You're a lifesaver, thank you!
Excellent !
3:05 When I do this, the grey line shifts, but the grey axis just follows it rightward, it doesn't create a gap. I don't know how to fix it :(
Try selecting the horizontal axis and then changing vertical axis crosses to axis value and setting it to whatever you want it to be
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
Kia ora Koutou! Thank you very much!
Any ideas as to why Excel wont let me group the two charts together at the end? The functionality appears to be disabled for charts but is available for objects.
Thank you !!
this is good thank you but i think for a proper 1 demands real axis alignment from PC side, python or google studio i guess
I have another video where I line the axis up properly ua-cam.com/video/bB7cjC_hDVg/v-deo.html
Wooow. You are a crack!! Thanks!
Very ingenious.
that was so professional, thank you
Congratulations!!! Nice job... I was thinking about using other software, but now it will not be necessary. Thanks.
I love your British accent
You are awesome - thank you for this great explanation!
Perfect video. Thank you very much!
Can we do this process in ms Excel 2007?
Great Video, Straight to the Point and Great trick 🤟
Brilliant! Thank you
thank you, saving me from paid multi axis chart maker
there is no 'Bound' option when i double click on the x axis under axis option. Help
it was a good tutorial on how to put another chart on the main one, the title does not match!
Greetings for u❤❤❤❤
unfortunately, the graph doesnt move somehow, even though i change axis option. The y-Axis take along a right shift ;(
unfortunately In my Excel Version there is no option to format x axis like that :'(
very nice! thanks
Helpful
It is great and helpful 🙏🏻
Brilliant! Thanks for the smart idea~
this is so hacky. micr should implement unlimited axis in excel in the first place, save us all a lot of grief and head bang on the table.
Thanks a lot
3:26 setting minimum and maximum is not working with me
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
Thank you so much for the tip. I find it very helpful
Your office year ?
thanks
fantastic. Can you make a video on how to make an axis break ? thanks
when I double click on x axis, it couldnt open min or max bounds menu so I couldnt do this
what if most of the values are qualitative?
when i change the bounds, the chart size stays the same. how do i make the chart size change when the bounds are adjusted??
When you set a minimum, scroll down to vertical axis crosses. Select axis value and input the minimum you set. With a little bit of tweaking and adjustments, you'll find the perfect balance.
Chapeau, congrats
Awesome
Cool, thanks.
thank you
Thanks
Great
Amazing
Gosh! Amazing.
Hello. Is it possible to make an average line of these 3 lines?
Thank you
Id rather sladh my wrists than even learn excel
why do you put a period after. every. single. word. you. say.?
genius !!
How about 5 Axis please
genius
Dear Microsoft. There has to be a better way. Sincerely, all users.
❤
This method doesn't work if X axis is starting from 0
You can still get this to work. Go to axis options and change the minimum bound to a negative number. Then change the 'vertical axis crosses' to 'axis value' and change the axis value to match the minimum bound.
It's appaling that excel doesn't support this properly
Pity Excel doesn't support a simple way to do this.
Unacceptable by my professors. There's gotta be an easier / correct way
There is another method that you can try ua-cam.com/video/bB7cjC_hDVg/v-deo.html
Horrible. You move with the movers
This is not a way ..this is cheating 😅
Excellent!
Thank you!!
Cool, thanks.