how to plot a graph in excel with an equation

For instance, if an organization wanted to determine the number of sales required for a particular product to cover its cost, they might type '=(A2*25)-2500.' Here, the '25' represents the price for their item, '2,500' represents their total costs to produce the item and the '*' symbol represents a multiplication sign. In cell B2, type the '=' symbol with your formula directly after it without a space. Related: How To Calculate ROI Using Excel 4. In the 'Defined Names' group, click 'Define Name' and enter 'x' in the 'Name' box. To do this, click the 'Formulas' tab at the top of your page. You need to define the meaning of the values of column A, so that Excel knows that each value in A equals a value of x. Once you enter your desired amount of variables, select all the x variables in column A by highlighting A2 and dragging your cursor down to the last cell you want to plot. If your graph charted numbers by 10 through 100, you'd include '10' in cell A2, '20' in cell A3, '30' in cell A4 and so on through '100' in A11. Next, type your input variables in the column underneath the header 'x.' These are the values of x you want to use on the horizontal axis of your graph and can be negative, positive, fractional or any combination of these types of numbers. You also can use more specific headers, such as 'Number of sales' and 'Revenue' to label the columns. Then enter 'y' in cell B1 for the output variables.

In cell A1, you can enter 'x' to represent the input column. Create your headersĪt the top of your Excel spreadsheet, enter your headers to distinguish which column is the input and which is the output. Find the green icon with the 'x' over the spreadsheet either in your control panel or by searching your applications for 'Excel.' You can then open an existing spreadsheet file or create a new one by pressing the 'New' option. To graph functions in Excel, first, open the program on your computer or device. How to graph functions in ExcelĬonsider the following steps to graph functions in Excel: 1. In this article, we discuss how to graph functions in Excel, provide tips to help you and answer other related questions. Understanding the steps to take to when graphing a function in Excel can help you determine your organization's profits or other related variables. Individuals can use this software program to graph functions that showcase solutions to a preset formula. Microsoft Excel allows individuals to represent their data visually with graphs and charts.

How to plot a graph in excel with an equation