How to Make a Line Graph in Excel

  Рет қаралды 1,145,527

Kevin Stratvert

Kevin Stratvert

Күн бұрын

Пікірлер: 155
@KevinStratvert
@KevinStratvert 4 жыл бұрын
🏫 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: kzbin.info/aero/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
@johnamoyaw2803
@johnamoyaw2803 4 жыл бұрын
I am interested in your primary and secondary graphs will be needed your very much support in this regards.
@T.Chittesh
@T.Chittesh 5 ай бұрын
bob
@calebcannon3644
@calebcannon3644 2 жыл бұрын
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.
@alexross26
@alexross26 4 жыл бұрын
i hate excel. i tried to do exactly this and it doesnt work
@gamefreak369
@gamefreak369 4 жыл бұрын
same asf nothing comes up
@brokenmousegamingreactions956
@brokenmousegamingreactions956 3 жыл бұрын
make sure your data doesn't have any units, excel gets tricked up on things like that
@garcia7569
@garcia7569 3 жыл бұрын
@@brokenmousegamingreactions956 same u saved me
@joshuathompson4471
@joshuathompson4471 11 ай бұрын
I believe we are all witnessing a teacher who claims he's Microsoft pro... Yet nobody can follow his instructions 🤣
@dhyeybagtharia7866
@dhyeybagtharia7866 10 ай бұрын
Me 2
@MEXTguide_yoyo
@MEXTguide_yoyo Жыл бұрын
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!
@yoyokanamihue6183
@yoyokanamihue6183 3 жыл бұрын
THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!
@hayleemiller9634
@hayleemiller9634 4 жыл бұрын
THANK YOU FULL TIME EMPLOYEE THIS WORKS!!!!!!!!!!!!!!!!!!!!!!!!!
@ItsSaraMackenzie
@ItsSaraMackenzie 4 жыл бұрын
I could cry learning about recommended charts :,)
@aivytruong8990
@aivytruong8990 4 жыл бұрын
So true
@ruairi9109
@ruairi9109 2 жыл бұрын
I could cry making them
@PerfectMo
@PerfectMo 2 жыл бұрын
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
@hellowaves
@hellowaves 3 жыл бұрын
You make it so seem so easy, thank you very much for all your time and effort you put into these videos.
@CesarBermudez-eq1gs
@CesarBermudez-eq1gs 3 ай бұрын
I have deff leveled up in my career with your help. Keep making a difference out here
@babs9269
@babs9269 4 жыл бұрын
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
@jocelyn_liu Жыл бұрын
No one ever helped him 😔
@babs9269
@babs9269 Жыл бұрын
@@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 😂😂😂
@soluteemoji
@soluteemoji Жыл бұрын
It’s wack definitely in the select data menu. Also sophomore using excel for bs.
@rimatabrah9418
@rimatabrah9418 Жыл бұрын
Kevin you made my entire day easier ☺️
@peterrivera3580
@peterrivera3580 8 ай бұрын
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.
@NdumisoBoyce-tn9jt
@NdumisoBoyce-tn9jt 6 ай бұрын
Keep up the good work 🎉
@imho2278
@imho2278 Жыл бұрын
Someone ate a heck of a lot in the last 2 years!
@alamore5084
@alamore5084 11 ай бұрын
REALLY HELPFUL thank you! Demystifying excel in a clear simple way.
@mikeprovost
@mikeprovost 10 ай бұрын
Thank you for this. You made it super easy.
@utilars
@utilars Жыл бұрын
0:15 - Dude, is that *you* in the wallpaper? If so AWESOME and GNARLY!!!
@joepark6249
@joepark6249 3 жыл бұрын
Great presentation!!
@sumansk6045
@sumansk6045 4 ай бұрын
Thank You 😊
@sanchezaisosa4048
@sanchezaisosa4048 8 ай бұрын
Thanks man. Super helpful
@snortons1
@snortons1 Жыл бұрын
Thank you Kevin!
@JuanPyro
@JuanPyro Жыл бұрын
Very helpful :) Thanks!
@pawanbhat175
@pawanbhat175 2 жыл бұрын
thank u my friend it helped my friend who dint upadated her ms office 😁😁😁😁😁😁😁
@d.tt.wilding7740
@d.tt.wilding7740 3 жыл бұрын
thank you!! enjoy your day,
@ujwalkandimalla9313
@ujwalkandimalla9313 9 ай бұрын
❤❤❤wonderful I made it
@MiuArtStudioUK
@MiuArtStudioUK 2 жыл бұрын
thanks, Kelvin!
@ash1ey100
@ash1ey100 Жыл бұрын
Thank you, massive help
@NidhiSingh-fi5qg
@NidhiSingh-fi5qg 4 ай бұрын
Thankyou it worked
@Mart_smith08
@Mart_smith08 3 жыл бұрын
thank you this took me forever to do!!!!
@jusperomwenga4549
@jusperomwenga4549 Жыл бұрын
Very clear explanation. Thank you
@hecpocalypse1171
@hecpocalypse1171 Жыл бұрын
Thanks man! This was very helpful!
@lschwa01
@lschwa01 Жыл бұрын
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!
@ravjc55
@ravjc55 Жыл бұрын
thanks so much. very helpful.
@skinnyd_tk6795
@skinnyd_tk6795 Жыл бұрын
due to videos like this i feel like i arrived in the 21st century, thanks alot
@michaelpeele4295
@michaelpeele4295 Жыл бұрын
This was extremely helpful! THANK YOU!
@noriahtalib
@noriahtalib 2 жыл бұрын
It is always easy to follow your tutorial. Thank you very much
@aliturnbull8366
@aliturnbull8366 4 жыл бұрын
Good video, man. Almost exactly what i was looking for!
@airlanggabhumintaraamitaba8363
@airlanggabhumintaraamitaba8363 2 жыл бұрын
Thank you, helps me a lot
@alexandriarinaldi029
@alexandriarinaldi029 2 жыл бұрын
Thank you so much, it was really helpful
@aykutyldz1538
@aykutyldz1538 3 жыл бұрын
thank you very much for this helpful tutorial
@lorettarodman9117
@lorettarodman9117 2 жыл бұрын
That combo was a life saver for my fly report thank you magic Kevin
@gionik5019
@gionik5019 Жыл бұрын
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?
@linasiddiqui9831
@linasiddiqui9831 4 жыл бұрын
are u the voice on daily dose of internet
@bobbyjanephoka3220
@bobbyjanephoka3220 7 ай бұрын
good stuff
@priyanshiprajapati5816
@priyanshiprajapati5816 8 ай бұрын
Thank you !!! 😊😊 Please please take good care watch this video if you think you are having trouble in making graphs..👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻this will help you..!
@jennyjoe1278
@jennyjoe1278 Жыл бұрын
Very helpful
@00830616herman
@00830616herman 4 жыл бұрын
Thank you! I found this very helpful!
@agk2249
@agk2249 9 ай бұрын
Thankyou brother
@khannetta3056
@khannetta3056 3 жыл бұрын
very nice
@matthewantonius3940
@matthewantonius3940 Жыл бұрын
love Kevin
@stickom
@stickom 2 жыл бұрын
10+ you are blessing, tomorrow presentation at meeting they gonna think I am smart, yes!
@desmondtas
@desmondtas 4 жыл бұрын
So helpful!
@cheekymonkeygirl3378
@cheekymonkeygirl3378 Жыл бұрын
Do you teach intermediate to advanced Excell too? I'm interested in buying your course.
@thewashhouse1864
@thewashhouse1864 2 жыл бұрын
excellent video to the point no nonsense!
@muhammadfaheel9578
@muhammadfaheel9578 Жыл бұрын
Thank you
@aivytruong8990
@aivytruong8990 4 жыл бұрын
Very helpful, thanks!
@gmo709
@gmo709 3 жыл бұрын
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.
@phakyou
@phakyou 7 ай бұрын
How do you make x-axis equally spaced?
@realknowledge8130
@realknowledge8130 2 ай бұрын
can we add text deta in vertical axis
@solarpanelsarecool
@solarpanelsarecool 5 жыл бұрын
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.
@UnscaryGhosts
@UnscaryGhosts 4 жыл бұрын
Yeah I learned the hard way too, just use google sheets
@FitilagiFaanunu
@FitilagiFaanunu 4 ай бұрын
How can I plot a graph for temperature variation and some values are missing or it is 0?
@leisamaribekkers312
@leisamaribekkers312 3 жыл бұрын
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.
@jasmines-n5126
@jasmines-n5126 4 жыл бұрын
So helpful
@kingaminglegend9269
@kingaminglegend9269 Жыл бұрын
Thank bro
@Niki-gg2fw
@Niki-gg2fw Жыл бұрын
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?
@yashvardhangupta7398
@yashvardhangupta7398 2 жыл бұрын
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 :)
@santosgiri25
@santosgiri25 4 жыл бұрын
Can you please show negative slope and r squared value as well ?
@GueshGebremeskel-i1l
@GueshGebremeskel-i1l 10 ай бұрын
1OQ for your explanition.
@aliceleung2906
@aliceleung2906 7 ай бұрын
Hi guys, how to send it to the gmail???
@goosecubes
@goosecubes 4 жыл бұрын
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.
@johnsknows3135
@johnsknows3135 Жыл бұрын
thx!
@gracemayberry5753
@gracemayberry5753 2 жыл бұрын
thank you so much and you are pretty good. You make it easy. Can you do pivot charts too.
@hvfynbcduovxs1469
@hvfynbcduovxs1469 Жыл бұрын
thanks
@mrsmathsireland
@mrsmathsireland 4 жыл бұрын
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
@deepikagokhe1732
@deepikagokhe1732 2 жыл бұрын
Hello … can you tell 2D plot on mac
@muni0528
@muni0528 2 жыл бұрын
is there any other way of doing this in excel online?
@Bamaboompa
@Bamaboompa 4 жыл бұрын
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
@yunwohyow6861
@yunwohyow6861 4 жыл бұрын
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
@marcsapgian5523
@marcsapgian5523 3 жыл бұрын
Do we they open post in microsoft
@rguidry2243
@rguidry2243 2 жыл бұрын
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.
@joeg9561
@joeg9561 2 жыл бұрын
What about charting ranges. Is there a limit to data numbers?
@JoeTakagi00
@JoeTakagi00 5 ай бұрын
How to do multiple tables into one line chart
@TMcCoy-usa
@TMcCoy-usa Жыл бұрын
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!
@jamuniyakuchaikote1856
@jamuniyakuchaikote1856 5 жыл бұрын
Thanks
@lumpygravy38
@lumpygravy38 4 жыл бұрын
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.
@ajk9708
@ajk9708 5 ай бұрын
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
@octaviosivori4649
@octaviosivori4649 2 жыл бұрын
GOAT
@beyondlea
@beyondlea 3 жыл бұрын
Does anyone know how to start the line graph at 0?
@robertjahn4190
@robertjahn4190 3 жыл бұрын
I think you would need a data point for that.
@cierralucas797
@cierralucas797 Жыл бұрын
You You're a cutie :) Thanks for the tutorial!
@alibadr6381
@alibadr6381 Жыл бұрын
How can I make a jagged line? What does a jagged line mean?
@somitabasak1843
@somitabasak1843 4 жыл бұрын
Thank you that was great do you have one on how to create a line graph that changes from solid line to dotted line?
@wordcarr8750
@wordcarr8750 Жыл бұрын
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?
@daxgulliver8763
@daxgulliver8763 8 ай бұрын
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
@thyagarajsiddappa7507
@thyagarajsiddappa7507 3 жыл бұрын
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
@Jeff-zc6rr
@Jeff-zc6rr Жыл бұрын
just switch the columns. But the x axis must be in order.
@lyongreene8241
@lyongreene8241 3 жыл бұрын
I dont see the plus sign on the side
@kleec6078
@kleec6078 3 ай бұрын
I have four sets of data that I need to enter and it’s not coming out the right way
@AaronMcIvor-hk6cd
@AaronMcIvor-hk6cd 2 жыл бұрын
I don't understand why you explain it this way? Why don't you just say to put all the data in first and then choose recommended chart. That will just give you a chart with all the other lines for the graphs without doing the other steps. I was lost for like 3 hours watching your video and then I just did it the straightforward way and it just recommended me the correct chart? I will say that I wouldn't even have known how to do that without watching your video the first place, so thank you.
@rinconscorner6347
@rinconscorner6347 4 жыл бұрын
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.
@OlgaPurnamaBakti
@OlgaPurnamaBakti 2 жыл бұрын
Mas, semoga hidupnya sehat selalu ya!
Excel Charts and Graphs Tutorial
24:31
Kevin Stratvert
Рет қаралды 707 М.
How to make a line graph in excel ( Multiple Lines Graph with markers)
12:12
It’s all not real
00:15
V.A. show / Магика
Рет қаралды 20 МЛН
📊 How to Build Excel Interactive Dashboards
19:21
Kevin Stratvert
Рет қаралды 2,7 МЛН
Excel Charts & Graphs: Learn the Basics for a Quick Start
14:10
Leila Gharani
Рет қаралды 1,1 МЛН
How to Make a Line Graph in Excel - From Simple to Scientific
9:04
Teacher's Tech
Рет қаралды 729 М.
How Many Rooks to BEAT Martin?
15:52
iwantcheckmate
Рет қаралды 22 М.
Master Data Analysis on Excel in Just 10 Minutes
11:32
Kenji Explains
Рет қаралды 2,3 МЛН
What Berliners Love and Hate About Their City | Easy German 588
11:32
Forecasting in Excel Tutorial
11:23
Kevin Stratvert
Рет қаралды 309 М.
EASILY Make an Automated Data Entry Form in Excel
14:52
Kenji Explains
Рет қаралды 996 М.