How to Make a Line Graph in Excel
ฝัง
- เผยแพร่เมื่อ 24 ก.ค. 2024
- 🔥 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... - วิทยาศาสตร์และเทคโนโลยี
🏫 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: th-cam.com/play/PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY.html
I am interested in your primary and secondary graphs will be needed your very much support in this regards.
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
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?
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 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.
THANK YOU!!!! Took me half an hour to give up and 5 seconds to follow yours!
Can you please show negative slope and r squared value as well ?
It is always easy to follow your tutorial. Thank you very much
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
THANK YOU FULL TIME EMPLOYEE THIS WORKS!!!!!!!!!!!!!!!!!!!!!!!!!
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 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! I found this very helpful!
Good video, man. Almost exactly what i was looking for!
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
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.
That combo was a life saver for my fly report thank you magic Kevin
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.
Thank you that was great do you have one on how to create a line graph that changes from solid line to dotted line?
What about charting ranges. Is there a limit to data numbers?
Very helpful, thanks!
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?!
So helpful!
This was extremely helpful! THANK YOU!
thank you so much and you are pretty good. You make it easy. Can you do pivot charts too.
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.
Kevin you made my entire day easier ☺️
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?
I could cry learning about recommended charts :,)
So true
I could cry making them
Great presentation!!
REALLY HELPFUL thank you! Demystifying excel in a clear simple way.
Very helpful. Thank you.
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.
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.
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?
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?
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
Very clear explanation. Thank you
Do we they open post in microsoft
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
Thanks man! This was very helpful!
excellent video to the point no nonsense!
thank you!! enjoy your day,
Thanks. This was helpful.
thank you very much for this helpful tutorial
is there any other way of doing this in excel online?
How do you make x-axis equally spaced?
Thank you so much, it was really helpful
Thankyou brother
Thank you for this. You made it super easy.
Thank you, helps me a lot
Hello … can you tell 2D plot on mac
Thanks
Thanks man. Super helpful
Thank you Kevin!
So helpful
Thank you, massive help
thank you this took me forever to do!!!!
Keep up the good work 🎉
Very helpful :) Thanks!
thanks so much. very helpful.
Thank you
Thank you !!! 😊😊 Please please take good care watch this video if you think you are having trouble in making graphs..👍🏻👍🏻👍🏻👍🏻👍🏻👍🏻this will help you..!
due to videos like this i feel like i arrived in the 21st century, thanks alot
❤❤❤wonderful I made it
Do you teach intermediate to advanced Excell too? I'm interested in buying your course.
Hi guys, how to send it to the gmail???
Thank bro
good stuff
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.
thx!
Very helpful
thanks, Kelvin!
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!
Someone ate a heck of a lot in the last 2 years!
thanks
very nice
0:15 - Dude, is that *you* in the wallpaper? If so AWESOME and GNARLY!!!
I dont see the plus sign on the side
love Kevin
Does anyone know how to start the line graph at 0?
I think you would need a data point for that.
thank u my friend it helped my friend who dint upadated her ms office 😁😁😁😁😁😁😁
How to do multiple tables into one line chart
are u the voice on daily dose of internet
10+ you are blessing, tomorrow presentation at meeting they gonna think I am smart, yes!
How can I make a jagged line?
What does a jagged line mean?
1OQ for your explanition.
GOAT
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.
I want to master microsoft Excel
You
You're a cutie :) Thanks for the tutorial!
Mas, semoga hidupnya sehat selalu ya!
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.
Yo wafi
BIB mr hopp s' play houes Mana sa dfr efgcvyuj say so?
you speak in a youtube intonation
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.