只要您了解流程,在电子表格中添加图表就没什么大不了的。但是,您知道您可以在 Excel 或 Google Sheets 中制作曲线图(make a curved line graph in Excel or Google Sheets)吗?如果不是,您应该查看本教程,将锐利的边缘变成平滑的线条。
有时您可能需要在电子表格中插入图表以更美观地显示数据。图形或图表使电子表格富有成效并有吸引力地可视化数据。创建和添加图表(create and add a graph)非常简单——无论您使用的是Microsoft Excel还是Google 表格(Sheets)。默认图形的问题是锐边。尽管它定义了数据的确切起伏,但有些人不喜欢它。如果您是其中之一,则可以按照本指南平滑边缘。为了您的信息,您可以将图形的现有锐边转换为平滑角以及添加新的曲线图。无论哪种方式,您都不需要任何第三方插件。
如何在Excel(Excel)中制作曲线图
要在Excel(Excel)中制作平滑曲线图,请按照以下步骤操作 -
- 在电子表格中输入您的数据并选择它以制作图表。
- 转到插入(Insert)选项卡并插入二维折线图。
- 右键单击(Right-click)该行并选择Format Data Series。
- 转到填充和线条选项卡。
- 检查平滑线选项。
首先,您需要输入要用于创建图表的数据。之后,转到插入(Insert )选项卡,然后单击图表(Charts)部分中的插入折线图或面积图(Insert Line or Area Chart)按钮。之后,选择要在电子表格中显示的二维折线图。(2-D Line )
插入图表后,右键单击蓝线,然后选择“格式化数据系列”(Format Data Series)选项。
在您的右侧,您应该会看到一个面板,您需要从该面板切换到“填充和线条”(Fill & Line )选项卡。之后,在平滑线(Smoothed line)复选框中打勾。
您可以立即找到转换。
如何在Google(Google)表格中制作曲线图
要在Google 表格(Google Sheets)中制作曲线图,请按照以下步骤操作 -
- 输入所有数据并插入图表。
- 将图表转换为线。
- 从自定义(Customize)选项卡中选择平滑。(Smooth)
首先(First),您需要创建一个包含正确数据的电子表格。然后,选择所有数据,单击插入(Insert )按钮,然后从列表中选择图表。(Chart)
默认情况下,它会根据您的数据显示图表。您需要将其转换为折线图。为此,单击图表(Chart),展开图表类型(Chart type )下拉菜单,然后在线条(Line)标签下选择一些内容。
现在,转到自定义(Customise )选项卡,然后展开图表样式(Chart style)菜单。之后,在“平滑(Smooth )”复选框中打勾。
现在,应该改变锋利的边缘。
就是这样!希望本教程对您有所帮助。
How to make a curved line graph in Excel and Google Sheets
Adding a graph in a spreadsheet is no big dеal as long as you knоw the рrocess. Howеνer, do you know that you can make a curved line graph in Excel or Google Sheets? If no, you should check out this tutorial to turn 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. It is straightforward to create and add a graph – whether you are using Microsoft Excel or Google Sheets. The problem with the default graph is the sharp edges. Although it defines the exact ups and downs of your data, some people do not like it. If you are one of them, you can smoothen the edges by following this guide. For your information, you can convert existing sharp edges of a graph into a smoothen corner as well as add a new curved graph. Either way, you do not need any third-party add-on.
How to make a curved line graph in Excel
To make a smooth curved line graph in Excel, follow these steps-
- Enter your data in the spreadsheet and select it to make 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, you need to enter your data that you want to use to create the graph. After that, go to Insert tab and click the Insert Line or Area Chart button in the Charts section. After that, select a 2-D Line graph that you want to display in your spreadsheet.
After inserting the graph, right-click on the blue line, and select Format Data Series option.
On your right side, you should see a panel from where you need to switch to the Fill & Line tab. After that, make a tick in the Smoothed line checkbox.
You can 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 chart.
- Convert the Chart into Line.
- Select Smooth from the Customize tab.
First of all, you need to create a spreadsheet with the proper data. Then, select all the data, click the Insert button, and select Chart from the list.
By default, it shows a chart as per your data. You need to convert it to a line graph. For that, click on the Chart, expand the Chart type drop-down menu, and select something under the Line label.
Now, go to Customise tab, and expand the Chart style menu. Following that, make a tick in the Smooth checkbox.
Now, the sharp edges should be changed.
That’s it! Hope this tutorial will be helpful.