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
🏫 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
3 жыл бұрын
I am interested in your primary and secondary graphs will be needed your very much support in this regards.
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!
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 hate excel. i tried to do exactly this and it doesnt work
@gamefreak369
4 жыл бұрын
same asf nothing comes up
@brokenmousegamingreactions956
2 жыл бұрын
make sure your data doesn't have any units, excel gets tricked up on things like that
@garcia7569
2 жыл бұрын
@@brokenmousegamingreactions956 same u saved me
@joshuathompson4471
5 ай бұрын
I believe we are all witnessing a teacher who claims he's Microsoft pro... Yet nobody can follow his instructions 🤣
@dhyeybagtharia7866
4 ай бұрын
Me 2
You make it so seem so easy, thank you very much for all your time and effort you put into these videos.
THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!
THANK YOU FULL TIME EMPLOYEE THIS WORKS!!!!!!!!!!!!!!!!!!!!!!!!!
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
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
11 ай бұрын
No one ever helped him 😔
@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
7 ай бұрын
It’s wack definitely in the select data menu. Also sophomore using excel for bs.
It is always easy to follow your tutorial. Thank you very much
Good video, man. Almost exactly what i was looking for!
Thank you! I found this very helpful!
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.
This was extremely helpful! THANK YOU!
Kevin you made my entire day easier ☺️
REALLY HELPFUL thank you! Demystifying excel in a clear simple way.
That combo was a life saver for my fly report thank you magic Kevin
So helpful!
Very helpful, thanks!
Great presentation!!
Thanks man! This was very helpful!
thank you!! enjoy your day,
Keep up the good work 🎉
Very clear explanation. Thank you
Thank you for this. You made it super easy.
I could cry learning about recommended charts :,)
@aivytruong8990
3 жыл бұрын
So true
@ruairi9109
Жыл бұрын
I could cry making them
Thank you so much, it was really helpful
Very helpful. Thank you.
Thank you Kevin!
thank you very much for this helpful tutorial
Thank you, massive help
Thanks. This was helpful.
Thanks man. Super helpful
Thank you, helps me a lot
thank you this took me forever to do!!!!
Very helpful :) Thanks!
thanks so much. very helpful.
thanks, Kelvin!
❤❤❤wonderful I made it
Thankyou brother
So helpful
love Kevin
excellent video to the point no nonsense!
good stuff
Very helpful
Thank you
Can you please show negative slope and r squared value as well ?
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
due to videos like this i feel like i arrived in the 21st century, thanks alot
Thank bro
thank u my friend it helped my friend who dint upadated her ms office 😁😁😁😁😁😁😁
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?!
thx!
very nice
Someone ate a heck of a lot in the last 2 years!
Thanks
10+ you are blessing, tomorrow presentation at meeting they gonna think I am smart, yes!
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.
thanks
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?
thank you so much and you are pretty good. You make it easy. Can you do pivot charts too.
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 !!! 😊😊 Please please take good care watch this video if you think you are having trouble in making graphs..👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻this will help you..!
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
4 жыл бұрын
Yeah I learned the hard way too, just use google sheets
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?
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!
0:15 - Dude, is that *you* in the wallpaper? If so AWESOME and GNARLY!!!
1OQ for your explanition.
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.
are u the voice on daily dose of internet
What about charting ranges. Is there a limit to data numbers?
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
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.
GOAT
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.
Thank you that was great do you have one on how to create a line graph that changes from solid line to dotted line?
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!
How do you make x-axis equally spaced?
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?
Do we they open post in microsoft
is there any other way of doing this in excel online?
Do you teach intermediate to advanced Excell too? I'm interested in buying your course.
You You're a cutie :) Thanks for the tutorial!
Hi guys, how to send it to the gmail???
Hello … can you tell 2D plot on mac
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 :)
I dont see the plus sign on the side
THANKS!
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.
Does anyone know how to start the line graph at 0?
@robertjahn4190
3 жыл бұрын
I think you would need a data point for that.
How can I make a jagged line? What does a jagged line mean?
I want to master microsoft Excel
Mas, semoga hidupnya sehat selalu ya!
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
10 ай бұрын
just switch the columns. But the x axis must be in order.
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
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.
Yo wafi
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.
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.
you speak in a youtube intonation