If you want to make a graph in Excel that curves smoothly, there are a few things you need to do. First, create a new worksheet and enter the following data: A. Start with the X-axis and enter the number of students in your class. B. Next, start with the Y-axis and enter the average grade for each student. C. Finally, add a curve to your graph by selecting Insert > Graph > Line from the menu bar. Now that you have created your graph, it is time to customize it. First, select the line that you just inserted and click on the Properties button (it looks like a small gear). This will open up the Line Properties dialog box. In this dialog box, you will need to specify two important properties: The first property is called “Type” and it determines how your line will be displayed on your graph: as a straight line or as a curve. The second property is called “Start Point” and it determines where on your X-axis (the starting point) your line will start. You can also change this property if you want your line to start at another point on the X-axis (for example, if you wanted it to start at halfway between each student’s value). Once you have set these properties, click on OK to close the Line Properties dialog box and return to your graph. Your curve should now be displaying correctly on your chart! ..
When you create a line graph in Excel, the lines are angled and have hard edges by default. You can easily change this to a curved graph with nice, smooth lines for a more polished look. We’ll walk you through the process step by step to convert your graph.
In this example, we want to create a curved line graph from this data on cookie sales.
Select and highlight the range A1:F2 and then click Insert > Line or Area Chart > Line.
The line graph is inserted with straight lines corresponding to each data point.
To edit this to a curved line, right-click the data series and then select the “Format Data Series” button from the pop-up menu.
Click the “Fill & Line” category and then check the box for “Smoothed Line.”
Using a smoothed line can help make your line graphs look smarter and more professional.
Smoothed lines can also be a clever way of distinguishing one data series from another. For example, targets from actuals or last year to this year.
RELATED: How to Work with Trendlines in Microsoft Excel Charts
