how to plot a graph in excel with an equation

Enter the following formula into cell B2, then copy the cell (Ctrl+C), select B3:B5, and paste (Ctrl+V). Enter X values of interest into A2 through A5. Enter descriptive headers into cells A1 and B1. Suppose for example you wanted to plot the relationship between the Fahrenheit and Celsius temperature scales. Then select this data and create an XY chart to show the relationship.Plot an Equation Using Worksheet Data To provide this data you need to enter X values into one column (or row), and calculate the corresponding Y values in the next column (or row). Excel charts aren't that smart, though: they can only plot data values that you assign. Simply choose a range of x-values to use in one column, then use an equation in a separate column to define the y-values based on the x-values.A common question new users ask is 'How can I plot an equation?' I think people expect that charts have a magical ability to accept an equation and spit out a graph of X vs. You can use a similar technique to plot any function or equation in Excel. Within the Charts group, click on the plot option called Scatter with Smooth Lines and Markers. Next, highlight the values in the range A2:B11. We can see that the plot follows a curved line downwards since this represents the equation y = 1/x. We can see that the plot follows a curved line since the equation that we used was quadratic. The following image shows how to create the y-values for this equation in Excel, using the range of 1 to 10 for the x-values: We can see that the plot follows a straight line since the equation that we used was linear in nature. The following plot will automatically appear: Within the Charts group, click on the plot option called Scatter.

The following image shows how to create the y-values for this linear equation in Excel, using the range of 1 to 10 for the x-values: Suppose you’d like to plot the following equation: This tutorial provides several examples of how to plot equations/functions in Excel. Fortunately this is easy to do with built-in Excel formulas. Often you may be interested in plotting an equation or a function in Excel.

How to plot a graph in excel with an equation