How to Make a Line Graph in Excel

Ғылым және технология

🔥 Learn Excel in just 2 hours: kevinstratvert.thinkific.com
Learn how to create line charts in Microsoft Excel with this step-by-step tutorial for beginners. As full disclosure, I work at Microsoft as a full-time employee.
Find out how to insert a recommended line graph. Also, learn how to insert a line chart directly and edit the horizontal and vertical axes.
Use this chart type to show trends over time (years, months, and days) or categories.
In this tutorial, I use Excel that comes with Office 365; however, this should also work with all previous versions of Excel, like Excel 2019, Excel 2016, Excel 2013, Excel 2010, Excel 2007, and Excel 2003.
See all Excel tutorial videos here: • ❎ How to use Excel
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com
Access the sample data in the spreadsheet here:
1drv.ms/x/s!AmxrofZZlZ-whINXe...

Пікірлер: 144

  • @KevinStratvert
    @KevinStratvert3 жыл бұрын

    🏫 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: kzread.info/head/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY

  • @johnamoyaw2803

    @johnamoyaw2803

    3 жыл бұрын

    I am interested in your primary and secondary graphs will be needed your very much support in this regards.

  • @MEXTguide_yoyo
    @MEXTguide_yoyo8 ай бұрын

    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!

  • @calebcannon3644
    @calebcannon3644 Жыл бұрын

    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
    @alexross264 жыл бұрын

    i hate excel. i tried to do exactly this and it doesnt work

  • @gamefreak369

    @gamefreak369

    4 жыл бұрын

    same asf nothing comes up

  • @brokenmousegamingreactions956

    @brokenmousegamingreactions956

    2 жыл бұрын

    make sure your data doesn't have any units, excel gets tricked up on things like that

  • @garcia7569

    @garcia7569

    2 жыл бұрын

    @@brokenmousegamingreactions956 same u saved me

  • @joshuathompson4471

    @joshuathompson4471

    5 ай бұрын

    I believe we are all witnessing a teacher who claims he's Microsoft pro... Yet nobody can follow his instructions 🤣

  • @dhyeybagtharia7866

    @dhyeybagtharia7866

    4 ай бұрын

    Me 2

  • @hellowaves
    @hellowaves2 жыл бұрын

    You make it so seem so easy, thank you very much for all your time and effort you put into these videos.

  • @yoyokanamihue6183
    @yoyokanamihue61833 жыл бұрын

    THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!

  • @hayleemiller9634
    @hayleemiller96343 жыл бұрын

    THANK YOU FULL TIME EMPLOYEE THIS WORKS!!!!!!!!!!!!!!!!!!!!!!!!!

  • @PerfectMo
    @PerfectMo Жыл бұрын

    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

  • @babs9269
    @babs92693 жыл бұрын

    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

    11 ай бұрын

    No one ever helped him 😔

  • @babs9269

    @babs9269

    11 ай бұрын

    @@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

    7 ай бұрын

    It’s wack definitely in the select data menu. Also sophomore using excel for bs.

  • @noriahtalib
    @noriahtalib2 жыл бұрын

    It is always easy to follow your tutorial. Thank you very much

  • @aliturnbull8366
    @aliturnbull83664 жыл бұрын

    Good video, man. Almost exactly what i was looking for!

  • @00830616herman
    @00830616herman3 жыл бұрын

    Thank you! I found this very helpful!

  • @peterrivera3580
    @peterrivera35802 ай бұрын

    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.

  • @michaelpeele4295
    @michaelpeele42959 ай бұрын

    This was extremely helpful! THANK YOU!

  • @rimatabrah9418
    @rimatabrah9418 Жыл бұрын

    Kevin you made my entire day easier ☺️

  • @alamore5084
    @alamore50845 ай бұрын

    REALLY HELPFUL thank you! Demystifying excel in a clear simple way.

  • @lorettarodman9117
    @lorettarodman9117 Жыл бұрын

    That combo was a life saver for my fly report thank you magic Kevin

  • @desmondtas
    @desmondtas4 жыл бұрын

    So helpful!

  • @aivytruong8990
    @aivytruong89903 жыл бұрын

    Very helpful, thanks!

  • @joepark6249
    @joepark62493 жыл бұрын

    Great presentation!!

  • @hecpocalypse1171
    @hecpocalypse117110 ай бұрын

    Thanks man! This was very helpful!

  • @d.tt.wilding7740
    @d.tt.wilding77403 жыл бұрын

    thank you!! enjoy your day,

  • @NdumisoBoyce-tn9jt
    @NdumisoBoyce-tn9jt10 күн бұрын

    Keep up the good work 🎉

  • @jusperomwenga4549
    @jusperomwenga4549 Жыл бұрын

    Very clear explanation. Thank you

  • @mikeprovost
    @mikeprovost4 ай бұрын

    Thank you for this. You made it super easy.

  • @ItsSaraMackenzie
    @ItsSaraMackenzie3 жыл бұрын

    I could cry learning about recommended charts :,)

  • @aivytruong8990

    @aivytruong8990

    3 жыл бұрын

    So true

  • @ruairi9109

    @ruairi9109

    Жыл бұрын

    I could cry making them

  • @alexandriarinaldi1070
    @alexandriarinaldi1070 Жыл бұрын

    Thank you so much, it was really helpful

  • @sesnc2145
    @sesnc21453 жыл бұрын

    Very helpful. Thank you.

  • @snortons1
    @snortons1 Жыл бұрын

    Thank you Kevin!

  • @aykutyldz1538
    @aykutyldz15382 жыл бұрын

    thank you very much for this helpful tutorial

  • @ash1ey100
    @ash1ey1006 ай бұрын

    Thank you, massive help

  • @user-wk7zc2vu2e
    @user-wk7zc2vu2e3 жыл бұрын

    Thanks. This was helpful.

  • @sanchezaisosa4048
    @sanchezaisosa40482 ай бұрын

    Thanks man. Super helpful

  • @airlanggabhumintaraamitaba8363
    @airlanggabhumintaraamitaba8363 Жыл бұрын

    Thank you, helps me a lot

  • @adolv_Heatlur239
    @adolv_Heatlur2392 жыл бұрын

    thank you this took me forever to do!!!!

  • @JuanPyro
    @JuanPyro7 ай бұрын

    Very helpful :) Thanks!

  • @ravjc55
    @ravjc5511 ай бұрын

    thanks so much. very helpful.

  • @MiuArtStudioUK
    @MiuArtStudioUK2 жыл бұрын

    thanks, Kelvin!

  • @ujwalkandimalla9313
    @ujwalkandimalla93133 ай бұрын

    ❤❤❤wonderful I made it

  • @agk2249
    @agk22493 ай бұрын

    Thankyou brother

  • @jasmines-n5126
    @jasmines-n51264 жыл бұрын

    So helpful

  • @matthewantonius3940
    @matthewantonius39408 ай бұрын

    love Kevin

  • @thewashhouse1864
    @thewashhouse18642 жыл бұрын

    excellent video to the point no nonsense!

  • @bobbyjanephoka3220
    @bobbyjanephoka3220Ай бұрын

    good stuff

  • @jennyjoe1278
    @jennyjoe1278 Жыл бұрын

    Very helpful

  • @muhammadfaheel9578
    @muhammadfaheel9578 Жыл бұрын

    Thank you

  • @santosgiri25
    @santosgiri254 жыл бұрын

    Can you please show negative slope and r squared value as well ?

  • @mrsmathsireland
    @mrsmathsireland3 жыл бұрын

    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

  • @skinnyd_tk6795
    @skinnyd_tk679510 ай бұрын

    due to videos like this i feel like i arrived in the 21st century, thanks alot

  • @kingaminglegend9269
    @kingaminglegend92697 ай бұрын

    Thank bro

  • @pawanbhat175
    @pawanbhat1752 жыл бұрын

    thank u my friend it helped my friend who dint upadated her ms office 😁😁😁😁😁😁😁

  • @fuckedinthepool8956
    @fuckedinthepool89569 ай бұрын

    Helped me greatly. Why am I being forced to do Python or R for making such a same graphs easily in Excel? Can you tell?!

  • @johnsknows3135
    @johnsknows313510 ай бұрын

    thx!

  • @khannetta3056
    @khannetta30562 жыл бұрын

    very nice

  • @imho2278
    @imho2278 Жыл бұрын

    Someone ate a heck of a lot in the last 2 years!

  • @jamuniyakuchaikote1856
    @jamuniyakuchaikote18564 жыл бұрын

    Thanks

  • @stickom
    @stickom Жыл бұрын

    10+ you are blessing, tomorrow presentation at meeting they gonna think I am smart, yes!

  • @gmo709
    @gmo7092 жыл бұрын

    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.

  • @hvfynbcduovxs1469
    @hvfynbcduovxs1469 Жыл бұрын

    thanks

  • @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?

  • @gracemayberry5753
    @gracemayberry5753 Жыл бұрын

    thank you so much and you are pretty good. You make it easy. Can you do pivot charts too.

  • @Bamaboompa
    @Bamaboompa3 жыл бұрын

    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

  • @priyanshiprajapati5816
    @priyanshiprajapati58162 ай бұрын

    Thank you !!! 😊😊 Please please take good care watch this video if you think you are having trouble in making graphs..👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻this will help you..!

  • @solarpanelsarecool
    @solarpanelsarecool4 жыл бұрын

    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

  • @gionik5019
    @gionik501910 ай бұрын

    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?

  • @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!

  • @utilars
    @utilars Жыл бұрын

    0:15 - Dude, is that *you* in the wallpaper? If so AWESOME and GNARLY!!!

  • @user-dx3js7if1i
    @user-dx3js7if1i4 ай бұрын

    1OQ for your explanition.

  • @lumpygravy38
    @lumpygravy384 жыл бұрын

    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.

  • @linasiddiqui9831
    @linasiddiqui98313 жыл бұрын

    are u the voice on daily dose of internet

  • @joeg9561
    @joeg9561 Жыл бұрын

    What about charting ranges. Is there a limit to data numbers?

  • @yunwohyow6861
    @yunwohyow68614 жыл бұрын

    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

  • @leisamaribekkers312
    @leisamaribekkers3123 жыл бұрын

    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.

  • @octaviosivori4649
    @octaviosivori4649 Жыл бұрын

    GOAT

  • @rguidry2243
    @rguidry22432 жыл бұрын

    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.

  • @somitabasak1843
    @somitabasak18433 жыл бұрын

    Thank you that was great do you have one on how to create a line graph that changes from solid line to dotted line?

  • @lschwa01
    @lschwa0111 ай бұрын

    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!

  • @phakyou
    @phakyouАй бұрын

    How do you make x-axis equally spaced?

  • @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?

  • @marcsapgian5523
    @marcsapgian55233 жыл бұрын

    Do we they open post in microsoft

  • @muni0528
    @muni05282 жыл бұрын

    is there any other way of doing this in excel online?

  • @cheekymonkeygirl3378
    @cheekymonkeygirl33788 ай бұрын

    Do you teach intermediate to advanced Excell too? I'm interested in buying your course.

  • @cierralucas797
    @cierralucas797 Жыл бұрын

    You You're a cutie :) Thanks for the tutorial!

  • @aliceleung2906
    @aliceleung2906Ай бұрын

    Hi guys, how to send it to the gmail???

  • @deepikagokhe1732
    @deepikagokhe1732 Жыл бұрын

    Hello … can you tell 2D plot on mac

  • @yashvardhangupta7398
    @yashvardhangupta73982 жыл бұрын

    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 :)

  • @lyongreene8241
    @lyongreene82412 жыл бұрын

    I dont see the plus sign on the side

  • @Joe-cr1yq
    @Joe-cr1yq Жыл бұрын

    THANKS!

  • @goosecubes
    @goosecubes3 жыл бұрын

    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.

  • @beyondlea
    @beyondlea3 жыл бұрын

    Does anyone know how to start the line graph at 0?

  • @robertjahn4190

    @robertjahn4190

    3 жыл бұрын

    I think you would need a data point for that.

  • @alibadr6381
    @alibadr63817 ай бұрын

    How can I make a jagged line? What does a jagged line mean?

  • @messimessi7255
    @messimessi72552 жыл бұрын

    I want to master microsoft Excel

  • @OlgaPurnamaBakti
    @OlgaPurnamaBakti Жыл бұрын

    Mas, semoga hidupnya sehat selalu ya!

  • @thyagarajsiddappa7507
    @thyagarajsiddappa75073 жыл бұрын

    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

    10 ай бұрын

    just switch the columns. But the x axis must be in order.

  • @daxgulliver8763
    @daxgulliver87632 ай бұрын

    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

  • @AaronMcIvor-hk6cd
    @AaronMcIvor-hk6cd Жыл бұрын

    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.

  • @aminhamid1307
    @aminhamid13072 жыл бұрын

    Yo wafi

  • @rinconscorner6347
    @rinconscorner63474 жыл бұрын

    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.

  • @andrewwilder2281
    @andrewwilder2281 Жыл бұрын

    Trabajo como voluntario en un parque. Entreno fútbol de bandera juvenil. Lo hago por los niños y padres de la ciudad. Ayudo a organizar eventos y les digo que soy voluntario en el parque Rob Sullivan en DeBary.

  • @rfcalm
    @rfcalm3 жыл бұрын

    you speak in a youtube intonation

Келесі