How to Graph a Function in Excel 2016

In this HowTech written tutorial, we’re going to show you how to graph functions in Excel 2016.
Don't forget to check out our main channel / howtech for more free how-to videos!
Join us on Facebook
/ howtechtv
Our App
bit.ly/how-tech
First, we need to create a table of values. As of yet, there is no functionality to graph a function by the equation alone.
We start with the x-coordinate as shown below.
Then, for example I want values from 0 to 10, I would simply type 0 in a row, and in the next row a 1. Highlight the two cells and hover the mouse over the small square in the bottom right of the selection until the cursor changes to a plus sign. Click and drag the selection downwards as shown below.
You should now see values from 0 to 10. We’ll now create the f(x) or y-coordinate table. Type in the equation you want in the formula bar highlighted below, or into the corresponding cell. The equation I used is as follows: =A2^3 + A2^2 + 5. The A2 cell being the corresponding x value. Now drag the equation down by dragging the small square in the bottom right of the selection as we did earlier and shown below to copy the equation to all x values.
Now to graph the equation, select the entire typed table and go to the Insert tab, click Scatter and click Scatter with Smooth Lines and Markers.
Your graph should now appear and be set. You can also change the title of the graph by clicking on the field and typing whatever you want in the text box.
This is a HowTech tutorial, visit our website and watch our videos for more!

[@howtechoffice]

❗ Subscribe To Our Main RUclips Channel
ruclips.net/user/howtechpc

[@emilio_319]

Excellent explanation and you got right to the point. Great video! Thank you!

[@Sami-ow9zp]

Thank you so much very short and to the point. Thanks again you made my day.

[@yagnatherapybydromtrivedi971]

This was the phenomenon, Thank you very much for it! 🙌🙏🏻

[@Pedro381ispro]

thank you very much this helped me a lot. clear concise and to the point. I cringe at anyone who thinks what you're showing is not a function.

[@kaustubhchakrabarti2400]

Thank you so much for this

[@kikowner]

Lifesaver for what I needed

[@francescovellani2057]

Thank you very much

[@katieruiz4339]

yo you rly helped me out my teacher was talking abt it and i was so lost

[@LiamC328]

Wow thank you man

[@palashjyotiborah3376]

Can you plz... Fit an exponential curve of the form y=ab^X for given data(discrete or continues).Hence ,required equation of the curve is y=AntilogB(AntilogB)^X

[@jacky5294]

thank you so much! you have helped me a lot with my project!

[@sethother8012]

But how do you add a line to an existing graph? For comparisons?

[@Hugo-xj2mj]

Thanks

[@tanyichun2535]

thank you very much for this tutorial

[@spongelena]

Hello! Thank you for the tutorial, I wanted to ask if I can do the opposite? Meaning, I have a graph and want to find the function. Thanks!

[@serinivasskumar6333]

thanks

[@Chrisymcmb]

Thanks m8

[@G5Hohn]

This is not graphing of a function. It's graphing some points from a function. A real function graph is continuous, not discrete.

[@hanymerehby5608]

"& thank you for watching"
Here is the comment you wanted 😁

[@hussainaradi7726]

first of all i like to thank you sir
but i have a question: can i Graph 2 or more functions in the same Excel?

[@tommasoravano5]

yes you can, just add a column to the data

[@hussainaradi7726]

@@tommasoravano5 thank you sir

[@nicparham9115]

This is not actually graphing the function. Only the integer points!

[@bkkoumi]

Thanks for sharing. It helps.

[@justinjoostrocks]

When I do this, it just makes two lines with the different columns.

[@Pedro381ispro]

probably irrelevant now but switch the graph setting. you should choose scatterplot

[@sorrymauree]

@@Pedro381ispro Mine is doing this too. Help

[@Pedro381ispro]

@@sorrymauree pretty sure when u right click there should be something called 'graph settings' or at the top somewhere there will be an option to edit the style and type of graph

[@sorrymauree]

@@Pedro381ispro Yeah it's not that simple, unfortunately. Ironically, Excel kinda makes it complicated to format graph settings. I think I have to add a series on the graph for the Y values so they are on the same line, but still, I asked my TA and he had no clue lol.

[@Fasteroid]

This is great and all, but I really wish excel didn't force you to waste cells to do this. It can graph trendlines... why can't it graph my functions with the same code? smh

[@andregoncalves5200]

I agree. There should be a way to plot a function from its equation only. Sometimes you only find the output values you are looking for after looking at the graph. Excel should have a way to operate like a graphic calculator, I mean, everything is already there.

[@draygerard4550]

thx :)

[@armandine2]

a million times too quick?

[@babakbandpey]

✌✌✌👍

[@VendPrekmurec]

I have 2 different lines. Fuck Excel

[@erasimo3611]

thank you so much