how to plot a graph in excel using a function

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 using a function