Alan Murray has functioned as an Excel trainer and consultant because that twenty years. On many days, he have the right to be uncovered teaching Excel in a class or seminar. Alan gets a buzz indigenous helping human being improve their productivity and also working resides with Excel. Check out more...
You are watching: How to graph a curved line
When you produce a line graph in Excel, the lines room angled and also have difficult edges by default. You deserve to easily adjust this to a curved graph through nice, smooth lines for a more polished look. We’ll to walk you v the process step by step to transform your graph.
In this example, we desire to produce a curved line graph native this data on cookie sales.
Select and highlight the variety A1:F2 and also then click Insert > heat or Area graph > Line.
The line graph is inserted with directly lines matching to every data point.
To modify this come a curved line, right-click the data series and then pick the “Format Data Series” button from the pop-up menu.
Click the “Fill & Line” category and also then check the crate for “Smoothed Line.”
Using a smoothed heat can assist make her line graphs look smarter and an ext professional.
Smoothed lines can also be a clever method of distinguishing one data collection from another. Because that example, targets from actuals or last year come this year.
See more: What Does An Arrow After A Command Indicate, What Does >> Or Double Angle Brackets Mean
RELATED: How to occupational with Trendlines in Microsoft Excel Charts
Alan MurrayAlan Murray has functioned as an Excel trainer and consultant because that twenty years. On most days, he deserve to be uncovered teaching Excel in a great or seminar. Alan gets a buzz native helping civilization improve your productivity and also working resides with Excel. Read full Bio »
JOIN geezer TALK top top FACEBOOK
The over article may contain affiliate links, which help support How-To Geek.
How-To geezer is wherein you turn as soon as you want experts to define technology. Because we introduced in 2006, our short articles have to be read an ext than 1 exchange rate times. Want to know more?