how to plot a graph in excel and get a funtion

Here, the software will try to determine the best chart that would display the relevant information clearly. In the variety of options, the recommended chart will need to be selected. This selection will display the following options. In the next step, the data needs to be selected in the following manner in order to continue with the creation of the chart.Īfter the selection has been made, the user will need to move on to Insert on the Menu bar. This data will be used to make the chart accordingly. The required data will need to be inserted into the excel sheet. How to Plot Graph in Excelįirst you have to start the excel software. The steps involved in making the chart will be relatively the same in many instances. So the excel software may come with a different interface. For the benefit of those, we will explain how to plot graph in Excel, giving you simple guidelines with illustrations. But some people find it is a struggle to plot graph with the use of the Excel software. It will make data more visual and comprehensive.

This will automatically calculate the area for the cells below, since they're all trapezoids.Charts and graphs are mainly used to present complex information in a clear and concise manner. Grab the fill handle and drop it on the cells below.Again, when the formula has the area of the segment, it sums it with the previous cell to get the total area so far. The bases are B3 and B4, and the height is A4-A3. A trapezoid's area is the sum of the two bases, multiplied by the height and then divided by two. Select the cell below and enter this formula: =(B3+B4)*(A4-A3)/2 + C3 This time, the segment is a trapezoid.Once the formula calculates the area, it then sums it with the previous cell, to get the total area. The height of this triangle is on the Y-axis, and it's B3. The height of this triangle is on the X-axis and is A3-A2. The area of a triangle is the height multiplied by the base and then divided by two. Select the cell below, and enter the formula below in the formula bar: =(A3-A2)*(B3)/2 + C2 This segment is a rectangle.Now let's calculate the area for the next segment. That is because the area at time zero is zero as well. In this example, that will also be the distance traveled, so we're going to use column C for this purpose. Select the cell where you want to show the area for the first segment.The first segment is going to be the area in time zero, which is naturally a zero.

How to plot a graph in excel and get a funtion