Home / Blog / How to Make a Curved Graph in Excel

How to Make a Curved Graph in Excel

Excel Logo

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.

Sample data for a line graph

Choose and spotlight the vary A1:F2 after which click on Insert > Line or Space Chart > Line.

Create a line graph

The road graph is inserted with straight strains corresponding to every knowledge level.

The first line graph with straight lines

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.

Format the data series of a line graph.

Click on the “Fill & Line” class after which verify the field for “Smoothed Line.”

Format a data series as a smoothed line

Utilizing a smoothed line can assist make your line graphs look smarter and extra skilled.

Curved line graph showing cookie sales

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

About Alan Murray

Check Also

How to Troubleshoot Bluetooth Issues on a Mac

Bluetooth provides you the liberty to make use of gadgets like keyboards and headphones wirelessly, …

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.