How To Draw A Line In Excel Graph

Download PC Repair Tool to apace find & gear up Windows errors automatically

Adding a graph in a spreadsheet is no large deal as long as you know the process. However, do you know that you tin can brand a curved line graph in Excel or Google Sheets? If no, you should cheque out this tutorial to plow the sharp edges into smoothed lines.

Sometimes you may need to insert a graph in a spreadsheet to show data more beautifully. A graph or chart makes the spreadsheet productive and attractively visualizes the data. Information technology is straightforward to create and add together a graph – whether you are using Microsoft Excel or Google Sheets. The problem with the default graph is the precipitous edges. Although it defines the verbal ups and downs of your data, some people do not like it. If you are one of them, y'all tin smoothen the edges by following this guide. For your information, you can catechumen existing sharp edges of a graph into a smoothen corner as well as add a new curved graph. Either style, you lot practice not need any third-political party add together-on.

How to make a curved line graph in Excel

To brand a smoothen curved line graph in Excel, follow these steps-

Enter your data in the spreadsheet and select it to brand a graph.
Go to Insert tab and insert a 2-D line graph.
Right-click on the line and select the Format Data Series.
Go to Fill & Line tab.
Check the Smoothed line option.

To get started, yous need to enter your information that you desire to use to create the graph. After that, go to Insert tab and click the Insert Line or Surface area Chart button in the Charts department. After that, select a ii-D Line graph that you desire to display in your spreadsheet.

Later on inserting the graph, correct-click on the blue line, and select Format Information Series option.

On your right side, you should come across a console from where you demand to switch to the Fill & Line tab. After that, make a tick in the Smoothed line checkbox.

Yous tin find the conversion immediately.

How to make a curved line graph in Google Sheets

To make a curved graph in Google Sheets, follow these steps-

Enter all data and insert a nautical chart.
Convert the Chart into Line.
Select Polish from the Customize tab.

First of all, y'all demand to create a spreadsheet with the proper data. And so, select all the data, click the Insert button, and select Chart from the listing.

Past default, it shows a nautical chart as per your data. You demand to convert it to a line graph. For that, click on the Nautical chart, expand the Chart type driblet-down menu, and select something under the Line label.

Now, go to Customise tab, and expand the Chart mode menu. Following that, make a tick in the Smooth checkbox.

Now, the abrupt edges should exist changed.

That's information technology! Hope this tutorial will be helpful.

Sudip loves to engage with the latest technology & gadgets. Apart from writing well-nigh all things technology, he is a Photoshop junkie and a football enthusiast.