🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com ⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I struggled around for hours to acheive what you managed to explain in less than 10 minutes and thanks to your explanation also managed to get what I wanted done in a much much much shorter time than I did while floundering around for this or that. My ignorance aside, thanks so much this has been super helpful!
how do i put three graphs together in one graph... i'm trying to put three data sets all in one for my econ class and can't seem to do it. Can you pls help me?
@@jocelyn_liu it’s okay. I’m a sophomore in college and I haven’t used this stuff, ever lol. I think I managed to figure it out but it was so long ago 😂😂😂
Amazing! Once I inserted the graph per your directions I took it to a new level with the myriad of available customizations. Thank you for your subject matter expertise.
I have a line chart with 4 years of weekly sales data by customer and brand. I have sliders for selections, but cannot get them to work for the year selection. When i add the year, it just shows 52 weeks to deselect. I want to take a specific year out. What is an easy way to remove a year? I have to rt click and remove, then go back and retract it to put back as it was.
If i have several days (5), each day contains several timestamps. I want to create a chart from this data. Firt a would like to create a formula that all timmes btwen 13:00 to 13:30 are counted togheter and all timed betwen 13:30 and 14;00 are counted together , is this ossible?
Having made many such presentations, I'd like to suggest that you speak and move the cursor more slowly, use a VERY legible (large) cursor, and pause after each action so that we can grasp what you did. Thanks for sharing!
Can you please show how to do a line chart with three lots of data for example for comparing results in percentages, of a specific treatment on 3 individuals over the same time period - that is 8 treatments over four weeks - Thankyou.
hello, if i have made an xy chart ( with numbers) and additionally to that i want to find a price on the y given that the price on the x is known how to i do that?
I'm old so techno-challenged. I have a graph following 5-6 teams. Each day each team wins, loses or sometimes ties so columns are Date, Team, Results - "w", "l", "t". How can I create a line graph with points to spot if a team is trending in one direction? Thanks
thank you for the tutoral. i have some negative and positive numbers in my list and I cannot get them to show up on a graph. its as if they are not recognised. any advice needed please.. thanks
I managed to bring up a line graph following your instruction. But there are too much empty space on the graph. Is there anyway I can email you my chart and see how it can be improved. Best regards
How do you make a line chart that excludes weekends and holidays (with horizontal axis as the date line)? This is for charting stock market data daily. Thanks!
When i try and create a histogram using data from yahoo finance , it says, text in input stage and does not allow me to. This only happens with certain data sets.Any ideas on how to rectify this annoying problem? Thanks.
Once a line graph is fully formed with all elements in place...suppose the X-axis (horizontal) went from 0 to 100%, as is normal as the smallest value is usually plotted at the origin, however, what if you wanted the X-axis values REVERSED so that the origin which originally was 0% would NOW be 100% with the numbers declining from left to right? It seems like this should be an easy option to create but is it?
Hi Kevin, I am having a problem changing X axis to Y axis and vice versa. Example ELEV FLOW 71.3 93.2 72.4 98.4 73.6 96.5 74.8 93.8 75.2 92.7 76.7 90.6 78.9 91.3 So, How to change as Flow in x-axis and Elev in Y-axis. Please show me Thanks Raj
great video, it really helped. Nevertheless, it is a line 'graph' not a line 'chart.' I am sorry it jus really bothered me. thanks for the video though :)
everytime I put ANY number in the chart it says 100% no matter what. I’m trying to illustrate fluctuations in account values over 20 years with a 50% drop after 2 years. But I can’t show anything but 0 or 100% I don’t get it Why is there even an option for me to put in numbers if all it’s going to do is 0 or 100 mine as well just be a mfing toggle switch, useless
Ok here is how to make a program to make microsoft graphs: 1st you make it as confusing and convoluted as possible, next you don't use common words like: x & y axis, or range & domain, or independent/dependent etc. Finally you have it not do what you want it to do despite doing everything right... Thank you for the video, it is still appreciated. It's not your fault micrsoft makes crap programs, not entirely anyways, or that they foist their nonsense down our throat and expect us to love it... Thank you still for the video. I couldn't get it to work but thank you.
There are still problems. It changes the axes values. Why something that was simple to do became so complicated is beyond me. It isn't intuitive anymore.
🏫 Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
⏭ Watch next - playlist with all my free tutorial videos on how to use Excel: ua-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I am interested in your primary and secondary graphs will be needed your very much support in this regards.
bob
I am glad that youtubers like you exist, cause with you I'd probably fail C.A.T. (Computer Applications Technology). South Africans love your videos.
I struggled around for hours to acheive what you managed to explain in less than 10 minutes and thanks to your explanation also managed to get what I wanted done in a much much much shorter time than I did while floundering around for this or that. My ignorance aside, thanks so much this has been super helpful!
THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!
i hate excel. i tried to do exactly this and it doesnt work
same asf nothing comes up
make sure your data doesn't have any units, excel gets tricked up on things like that
@@brokenmousegamingreactions956 same u saved me
I believe we are all witnessing a teacher who claims he's Microsoft pro... Yet nobody can follow his instructions 🤣
Me 2
how do i put three graphs together in one graph... i'm trying to put three data sets all in one for my econ class and can't seem to do it. Can you pls help me?
No one ever helped him 😔
@@jocelyn_liu it’s okay. I’m a sophomore in college and I haven’t used this stuff, ever lol. I think I managed to figure it out but it was so long ago 😂😂😂
It’s wack definitely in the select data menu. Also sophomore using excel for bs.
You make it so seem so easy, thank you very much for all your time and effort you put into these videos.
I have deff leveled up in my career with your help. Keep making a difference out here
literally the first tip you gave helped me. 1:00
I was stuck for a good min and the one they recommended was the one i needed. Thank you
I could cry learning about recommended charts :,)
So true
I could cry making them
THANK YOU FULL TIME EMPLOYEE THIS WORKS!!!!!!!!!!!!!!!!!!!!!!!!!
Amazing! Once I inserted the graph per your directions I took it to a new level with the myriad of available customizations. Thank you for your subject matter expertise.
Kevin you made my entire day easier ☺️
REALLY HELPFUL thank you! Demystifying excel in a clear simple way.
due to videos like this i feel like i arrived in the 21st century, thanks alot
Hi guys, how to send it to the gmail???
Thank you for this. You made it super easy.
can we add text deta in vertical axis
Someone ate a heck of a lot in the last 2 years!
How do you make x-axis equally spaced?
Keep up the good work 🎉
How do I do this with the online version of Excel? When I click 'select data' it only gives me the 'chart data range' not all the options you had.
Yeah I learned the hard way too, just use google sheets
I have a line chart with 4 years of weekly sales data by customer and brand. I have sliders for selections, but cannot get them to work for the year selection. When i add the year, it just shows 52 weeks to deselect. I want to take a specific year out. What is an easy way to remove a year? I have to rt click and remove, then go back and retract it to put back as it was.
How can I plot a graph for temperature variation and some values are missing or it is 0?
thank you!! enjoy your day,
If i have several days (5), each day contains several timestamps. I want to create a chart from this data. Firt a would like to create a formula that all timmes btwen 13:00 to 13:30 are counted togheter and all timed betwen 13:30 and 14;00 are counted together , is this ossible?
Having made many such presentations, I'd like to suggest that you speak and move the cursor more slowly, use a VERY legible (large) cursor, and pause after each action so that we can grasp what you did. Thanks for sharing!
Can you please show negative slope and r squared value as well ?
are u the voice on daily dose of internet
Very clear explanation. Thank you
It is always easy to follow your tutorial. Thank you very much
Do you teach intermediate to advanced Excell too? I'm interested in buying your course.
Thank you !!! 😊😊 Please please take good care watch this video if you think you are having trouble in making graphs..👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻this will help you..!
Great presentation!!
Thanks man. Super helpful
Can you please show how to do a line chart with three lots of data for example for comparing results in percentages, of a specific treatment on 3 individuals over the same time period - that is 8 treatments over four weeks - Thankyou.
0:15 - Dude, is that *you* in the wallpaper? If so AWESOME and GNARLY!!!
This was extremely helpful! THANK YOU!
That combo was a life saver for my fly report thank you magic Kevin
hello, if i have made an xy chart ( with numbers) and additionally to that i want to find a price on the y given that the price on the x is known how to i do that?
Hello … can you tell 2D plot on mac
Do we they open post in microsoft
is there any other way of doing this in excel online?
What about charting ranges. Is there a limit to data numbers?
I'm old so techno-challenged.
I have a graph following 5-6 teams.
Each day each team wins, loses or sometimes ties
so columns are Date, Team, Results - "w", "l", "t".
How can I create a line graph with points to spot if a team is trending in one direction?
Thanks
Thanks man! This was very helpful!
Good video, man. Almost exactly what i was looking for!
thank you this took me forever to do!!!!
thank u my friend it helped my friend who dint upadated her ms office 😁😁😁😁😁😁😁
thank you for the tutoral. i have some negative and positive numbers in my list and I cannot get them to show up on a graph. its as if they are not recognised. any advice needed please.. thanks
How to do multiple tables into one line chart
I managed to bring up a line graph following your instruction. But there are too much empty space on the graph. Is there anyway I can email you my chart and see how it can be improved. Best regards
Thankyou it worked
thank you very much for this helpful tutorial
Would like to see if you have many columns but want to select only 2 columns to graph out of the many. Your example only shows columns back to back.
How do you make a line chart that excludes weekends and holidays (with horizontal axis as the date line)? This is for charting stock market data daily. Thanks!
Thank You 😊
Thank you! I found this very helpful!
Thank you Kevin!
Very helpful :) Thanks!
I dont see the plus sign on the side
Thank you so much, it was really helpful
How can I make a jagged line?
What does a jagged line mean?
When i try and create a histogram using data from yahoo finance , it says, text in input stage and does not allow me to. This only happens with certain data sets.Any ideas on how to rectify this annoying problem? Thanks.
Thank you, massive help
Thank you, helps me a lot
thanks so much. very helpful.
thanks, Kelvin!
❤❤❤wonderful I made it
Once a line graph is fully formed with all elements in place...suppose the X-axis (horizontal) went from 0 to 100%, as is normal as the smallest value is usually plotted at the origin, however, what if you wanted the X-axis values REVERSED so that the origin which originally was 0% would NOW be 100% with the numbers declining from left to right? It seems like this should be an easy option to create but is it?
Hi Kevin, I am having a problem changing X axis to Y axis and vice versa. Example
ELEV FLOW
71.3 93.2
72.4 98.4
73.6 96.5
74.8 93.8
75.2 92.7
76.7 90.6
78.9 91.3
So, How to change as Flow in x-axis and Elev in Y-axis. Please show me Thanks Raj
just switch the columns. But the x axis must be in order.
my line chart start from zero, even my first value is $10k , i want my line data to start from 10k to forward .. how ? plz
thank you so much and you are pretty good. You make it easy. Can you do pivot charts too.
Very helpful
Thankyou brother
So helpful!
I have four sets of data that I need to enter and it’s not coming out the right way
Thank you that was great do you have one on how to create a line graph that changes from solid line to dotted line?
excellent video to the point no nonsense!
10+ you are blessing, tomorrow presentation at meeting they gonna think I am smart, yes!
great video, it really helped. Nevertheless, it is a line 'graph' not a line 'chart.' I am sorry it jus really bothered me. thanks for the video though :)
very nice
Does anyone know how to start the line graph at 0?
I think you would need a data point for that.
Very helpful, thanks!
everytime I put ANY number in the chart it says 100% no matter what. I’m trying to illustrate fluctuations in account values over 20 years with a 50% drop after 2 years.
But I can’t show anything but 0 or 100% I don’t get it
Why is there even an option for me to put in numbers if all it’s going to do is 0 or 100 mine as well just be a mfing toggle switch, useless
good stuff
1OQ for your explanition.
Ok here is how to make a program to make microsoft graphs: 1st you make it as confusing and convoluted as possible, next you don't use common words like: x & y axis, or range & domain, or independent/dependent etc. Finally you have it not do what you want it to do despite doing everything right... Thank you for the video, it is still appreciated. It's not your fault micrsoft makes crap programs, not entirely anyways, or that they foist their nonsense down our throat and expect us to love it... Thank you still for the video. I couldn't get it to work but thank you.
So helpful
Thank you
I want to master microsoft Excel
Im a simple person, I understand nothing
Thanks
Thank bro
thanks
love Kevin
There are still problems. It changes the axes values. Why something that was simple to do became so complicated is beyond me. It isn't intuitive anymore.
Mas, semoga hidupnya sehat selalu ya!
thx!
Worst software I have ever used.