How to make a chart with 3 axis in excel
ฝัง
- เผยแพร่เมื่อ 17 ก.ย. 2019
- Create two charts and line them up over the top of each other
---------------------------------------------------------------------------------
#exceltutorials #exceltips #excelcharts
SUBSCRIBE: goo.gl/c46YPs
Microsoft Office 365, 2016, Office Insider, Version 1910
These data are related to my PhD research
---------------------------------------------------------------------------------
IF YOU LIKED THIS VIDEO YOU MAY ALSO LIKE:
- How to make multiple charts using vba in excel • How to make multiple c...
- How to quickly make multiple charts in excel • How to quickly make mu...
- How to make panel charts in excel - method 1 • How to make panel char... - วิทยาศาสตร์และเทคโนโลยี
never thought in my lifetime i would be looking for a video : how to make 3 axis in excel...lmao thank you
We Need more people like you. You are born a teacher. Thank you
Very well delivered; not rushed and carefully sequenced steps. Thanks Karina! (I hope you will also share some day more axes!!!
Hope you learnt something new and interesting. Thanks for watching and please Like, Comment and Subscribe.
Excellent Karina, You just made my day
Thank you for going straight to the point!!
This is a lifesaver! Thank you!
Lots of respect! Thank you!
You're a hero, Karina!
superb tip. many thanks
Great tip 👍🏻.. thanks for sharing
thanks sister, great help for my thesis charts
I appreciate your knowledge
Kia ora Koutou! Thank you very much!
Thanks much, this is very helpful
Clever, clever, clever, thank you!
pretty bold channel name eh!
Thank you !!
This is seriously brilliant! Thank you 😃
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 so much for your course
You are awesome - thank you for this great explanation!
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?
simple solution for complicated data, this works for me, thank you
GOOD! SIMPLE IS BEST!!!
very nice! thanks
Wooow. You are a crack!! Thanks!
Great job. Thanks.
So so helpful and thank you! You are a great teacher Karina!
Thank you so much!
Cool, thanks.
Very ingenious.
i don't know u Karina, but I love you 😍 thank u very much for this!
Thanks a lot
Chapeau, congrats
Excellent !
Great Video, Straight to the Point and Great trick 🤟
REALLY HELPING ME SO MUCH THX!!!
Ya ya..quite genius and genuine
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
that was so professional, thank you
Helpful
thank you
Brilliant! Thank you
Brilliant! Thanks for the smart idea~
Can we do this process in ms Excel 2007?
Awesome...... Awesome...... Just awesome👌
Very productive.
This is art
Gosh! Amazing.
Amazing
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
there is no 'Bound' option when i double click on the x axis under axis option. Help
You're a lifesaver, thank you!
Perfect video. Thank you very much!
genius !!
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!
unfortunately, the graph doesnt move somehow, even though i change axis option. The y-Axis take along a right shift ;(
when I double click on x axis, it couldnt open min or max bounds menu so I couldnt do this
It is great and helpful 🙏🏻
Awesome
unfortunately In my Excel Version there is no option to format x axis like that :'(
Thank you so much for the tip. I find it very helpful
I love your British accent
Absolutely brilliant. Insert gif of exploding head here:
Great
it was a good tutorial on how to put another chart on the main one, the title does not match!
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
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 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.
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.
Thanks
fantastic. Can you make a video on how to make an axis break ? thanks
what if most of the values are qualitative?
genius
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.
❤
Greetings for u❤❤❤❤
The BEST tutorial! straight to the point no lengthy talking
Your office year ?
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.
Hello. Is it possible to make an average line of these 3 lines?
Thank you
Thanks Karina for the step-by-step explanation
thank you, saving me from paid multi axis chart maker
Congratulations!!! Nice job... I was thinking about using other software, but now it will not be necessary. Thanks.
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 tutorial, really help me
How about 5 Axis please
Thank You for your efforts. Well explained
why do you put a period after. every. single. word. you. say.?
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.
Id rather sladh my wrists than even learn excel
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
Dear Microsoft. There has to be a better way. Sincerely, all users.
Pity Excel doesn't support a simple way to do this.
This is not a way ..this is cheating 😅
Horrible. You move with the movers
Cool, thanks.
Thank you!!
genius