If you create a line graph in Excel, the strains are angled and have exhausting edges by default. You’ll be able to simply change this to a curved graph with good, easy strains for a extra polished look. We’ll stroll you thru the method step-by-step to transform your graph.
On this instance, we need to create a curved line graph from this knowledge on cookie gross sales.
Choose and spotlight the vary A1:F2 after which click on Insert > Line or Space Chart > Line.
The road graph is inserted with straight strains corresponding to every knowledge level.
To edit this to a curved line, right-click the info sequence after which choose the “Format Knowledge Collection” button from the pop-up menu.
Click on the “Fill & Line” class after which verify the field for “Smoothed Line.”
Utilizing a smoothed line can assist make your line graphs look smarter and extra skilled.
Smoothed strains may also be a intelligent method of distinguishing one knowledge sequence from one other. For instance, targets from actuals or final yr to this yr.
RELATED: Easy methods to Work with Trendlines in Microsoft Excel Charts