Adding a chart to a spreadsheet doesn’t matter as long as you know the process. However, do you know that you can create a line chart in Excel or Google Sheets? If not, you should check out this tutorial to transform sharp edges into smooth lines.
Sometimes you may need to insert a graph into a spreadsheet to display the data more beautifully. A graph or chart makes the spreadsheet productive and visually displays the data. It’s easy to create and add a chart, whether you’re using Microsoft Excel or Google Sheets. The problem with the default graphic is the sharp edges. Although it sets the exact highs and lows of your data, some people don’t like it. If you are one of them, you can smooth the edges by following this guide. For your information, you can convert the existing sharp edges of a graph into a smoother corner and add a new curved graph. In any case, you do not need any third-party add-ons.
How to create line chart in Excel
To create a smooth line chart in Excel, follow these steps:
- Enter your data into the spreadsheet and select it to create a graph.
- Go to the Insert tab and insert a 2D line graph.
- Right click on the line and select the format of the data series.
- Go to the Filling and line tab.
- Check the Smoothed Line option.
To start, you need to enter your data which you want to use to create the graph. After that go to Insert tab and click on the Insert a line or area chart button in the graphics section. After that select a 2D line graph you want to display in your spreadsheet.
After inserting the graph, right click on the blue line and select Data series format option.
On your right, you should see a sign from where you should go to Fill & Line tongue. After that, check the box Smooth line check box.
You can find the conversion immediately.
How to create a line chart in Google Sheets
To create a curved chart in Google Sheets, follow these steps:
- Enter all the data and insert a graph.
- Convert the graph online.
- Select Smooth in the Customize tab.
First, you need to create a spreadsheet with the appropriate data. Then select all the data, click on the Insert and select Graphic from the list.
By default, it displays a graph according to your data. You need to convert it to a line graph. To do this, click on the graph, expand the Type of chart drop down menu and select something under the Line label.
Now go to Personalize tab and expand the Chart style menu. Then check the box Smooth check box.
Now the sharp edges have to be changed.
That’s it! I hope you find this tutorial useful.