How to Make a Line Graph in Excel - Kevin Stratvert
video description
Date: 2022-03-15
Related videos
Comments and reviews: 10
Eduardo
Great video, Kevin. I have a question that no one at Microsoft has been able to answer. Many, many years ago, I used to be able to do something in Excel that was extremely useful for my line of work, which was to access the -Goal Seek- functionality via Excel's graphing function. You used to be able to 'grab' a graph value (e.g., a point on a given line graph) and alter it. If you 'moved' the data point that you had 'grabbed,' then it would ask you one of two things. If the graph was reading a value that had been hard-entered, it would ask you if you want to CHANGE the hard-entered cell value to the NEW value that the point on the graph had been moved to. However, if the graphed point referenced a FORMULA, then Excel would default to the -Goal Seek- function and you could 'seek' the value that would make the formula produce the value you visually wanted on the graph, specifically by tweaking the selected formula parameter--sheer genius IMO! Then one day, this functionality simply disappeared...I'm not sure, but I think it disappeared with Excel 2007. Do you know what happened? Did it get moved, but still works? Was it purposefully eliminated because of problems it may have caused? Or was it just 'left behind' inadvertently? I sorely miss it!! Any insight is helpful and appreciated! Thanks!!
reply
Great video, Kevin. I have a question that no one at Microsoft has been able to answer. Many, many years ago, I used to be able to do something in Excel that was extremely useful for my line of work, which was to access the -Goal Seek- functionality via Excel's graphing function. You used to be able to 'grab' a graph value (e.g., a point on a given line graph) and alter it. If you 'moved' the data point that you had 'grabbed,' then it would ask you one of two things. If the graph was reading a value that had been hard-entered, it would ask you if you want to CHANGE the hard-entered cell value to the NEW value that the point on the graph had been moved to. However, if the graphed point referenced a FORMULA, then Excel would default to the -Goal Seek- function and you could 'seek' the value that would make the formula produce the value you visually wanted on the graph, specifically by tweaking the selected formula parameter--sheer genius IMO! Then one day, this functionality simply disappeared...I'm not sure, but I think it disappeared with Excel 2007. Do you know what happened? Did it get moved, but still works? Was it purposefully eliminated because of problems it may have caused? Or was it just 'left behind' inadvertently? I sorely miss it!! Any insight is helpful and appreciated! Thanks!!
reply
boriquanking2000
Excel sucks and watching this video unfortunately didn't help. Microsoft is just not intuitive enough for the average lay person to learn. Its a huge learning curve, just like any Microsoft product, and doesn't do anything to assist with simple projects - such as making a chart on a spreadsheet. I may have spoiled myself with Google products (Sheets) which make it so easy to do this function. Coming from a small business owner/entrepreneur, Microsoft still has not sold me on their products. please send this feedback to your cohorts in Microsoft. I don't recommend any of their products to my clients for this very reason.
reply
Excel sucks and watching this video unfortunately didn't help. Microsoft is just not intuitive enough for the average lay person to learn. Its a huge learning curve, just like any Microsoft product, and doesn't do anything to assist with simple projects - such as making a chart on a spreadsheet. I may have spoiled myself with Google products (Sheets) which make it so easy to do this function. Coming from a small business owner/entrepreneur, Microsoft still has not sold me on their products. please send this feedback to your cohorts in Microsoft. I don't recommend any of their products to my clients for this very reason.
reply
justin
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.
reply
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.
reply
G.
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.
reply
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.
reply
Bamaboompa
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
reply
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
reply
Leisa
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.
reply
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.
reply
Lumpy
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.
reply
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.
reply
yun
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
reply
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
reply
Mrs
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
reply
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
reply
Yashvardhan
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 :)
reply
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 :)
reply
Add a review, comment
Other channel videos
