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?
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.
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.
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.
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?
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
Very well delivered; not rushed and carefully sequenced steps. Thanks Karina! (I hope you will also share some day more axes!!!
Excellent Karina, You just made my day
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.
You're a hero, Karina!
This is a lifesaver! Thank you!
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
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.
This is seriously brilliant! Thank you 😃
simple solution for complicated data, this works for me, 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
I appreciate your knowledge
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!
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.
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.
i don't know u Karina, but I love you 😍 thank u very much for this!
Thank you for going straight to the point!!
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
thanks sister, great help for my thesis charts
Thanks Karina for the step-by-step explanation
Lots of respect! Thank you!
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?
Thank you so much for your course
there is no 'Bound' option when i double click on the x axis under axis option. Help
Ya ya..quite genius and genuine
when I double click on x axis, it couldnt open min or max bounds menu so I couldnt do this
Great tip 👍🏻.. thanks for sharing
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.
superb tip. many thanks
unfortunately, the graph doesnt move somehow, even though i change axis option. The y-Axis take along a right shift ;(
Can we do this process in ms Excel 2007?
GOOD! SIMPLE IS BEST!!!
Thanks much, this is very helpful
REALLY HELPING ME SO MUCH THX!!!
So so helpful and thank you! You are a great teacher Karina!
This is art
unfortunately In my Excel Version there is no option to format x axis like that :'(
Absolutely brilliant. Insert gif of exploding head here:
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.
I love your British accent
Awesome...... Awesome...... Just awesome👌
Thank you !!
Great job. Thanks.
Very productive.
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.
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 th-cam.com/video/bB7cjC_hDVg/w-d-xo.html
Thank You for your efforts. Well explained
Congratulations!!! Nice job... I was thinking about using other software, but now it will not be necessary. Thanks.
Kia ora Koutou! Thank you very much!
Very ingenious.
Your office year ?
You are awesome - thank you for this great explanation!
it was a good tutorial on how to put another chart on the main one, the title does not match!
what if most of the values are qualitative?
Wooow. You are a crack!! Thanks!
Thank you so much!
You're a lifesaver, thank you!
thank you, saving me from paid multi axis chart maker
Great Video, Straight to the Point and Great trick 🤟
Excellent !
thank you so much for the tutorial, really help me
that was so professional, thank you
Hello. Is it possible to make an average line of these 3 lines?
Thank you
Brilliant! Thank you
Greetings for u❤❤❤❤
very nice! thanks
Perfect video. Thank you very much!
Helpful
Chapeau, congrats
fantastic. Can you make a video on how to make an axis break ? thanks
Thanks a lot
Id rather sladh my wrists than even learn excel
It is great and helpful 🙏🏻
Gosh! Amazing.
How about 5 Axis please
Cool, thanks.
thank you
why do you put a period after. every. single. word. you. say.?
Amazing
Thank you so much for the tip. I find it very helpful
thanks
Awesome
Brilliant! Thanks for the smart idea~
Thanks
Great
genius !!
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.
genius
It's appaling that excel doesn't support this properly
Dear Microsoft. There has to be a better way. Sincerely, all users.
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 th-cam.com/video/bB7cjC_hDVg/w-d-xo.html
Horrible. You move with the movers
This is not a way ..this is cheating 😅
Excellent!
Thank you!!
Cool, thanks.