图表和图形(Charts and Graphs)是用于向客户传达信息的有用工具。复杂的数值数据通常以图形形式呈现,以便于理解和记忆。数据的图形表示有助于快速呈现一段时间内的信息及其发展趋势。
图表和图形等视觉图像也有助于突出容易记住和理解的重要事实。图表最常用于商业和日常任务,让您以视觉上吸引人的方式轻松查看趋势和比较。无论您是想通过演示文稿来构建报告,图表在向您的受众可视化复杂数据分析方面都发挥着重要作用。
如今,谷歌表格(Google Sheets)被认为是Excel的可行替代品,因为它可以从任何设备进行在线访问。与Excel一样,Google 表格(Google Sheets)包含各种功能来自动执行任务并提高工作效率。这个基于 Web 的应用程序让您可以像任何其他电子表格一样生成图表,以向观众传达事实。它具有广泛的图形和图表,您可以免费选择它们以视觉上吸引人的方式传达数据。
在本文中,我们将介绍如何在Google 表格(Google Sheets)中自动生成图表。
在 Google 表格中生成图表
启动Google 表格(Google Sheets)并创建一个新的电子表格或打开一个现有的表格。
将数据填充(Fill)到单元格中,并使用列标题组织数字事实。
导航到插入(Insert)并从下拉菜单中选择选项图表。( Chart)弹出一个图表编辑器窗口。
单击图表编辑器窗口中的选项设置(Setup)。
在图表类型(Chart type)字段中,从下拉菜单中选择要创建的图表类型。Google 表格(Google Sheets)提供了 30 种图表,您可以选择为您的数据创建图表。
在“数据范围(Data range)”字段中,选择要在表格中显示的单元格范围。您可以选择手动输入范围或使用指针选择数据范围。
输入数据范围后,单击“确定”。(OK.)
Google 表格(Google Sheet)现在将创建并显示一个图表,其中包含从表格中的单元格范围中选择的所有数据。
现在,如果您对工作表中的数据进行任何更改,图表将使用新结果自动更新,而无需为更新的值创建新图表。
您还可以在Google 表格(Google Sheets)中轻松更改相同数据的图表类型。
要更改图表类型,请双击图表。这将打开一个图表编辑器(Chart Editor)菜单。
转到设置(Setup)并在图表类型(Chart type)字段中从下拉菜单中选择一个新类型。
单击OK,Google 表格(Google Sheet)会将图表转换为您的数据的新图表样式。
在 Google 表格中自定义图表
此外,Google 表格(Google Sheets)允许您根据数据完全自定义图表。自定义选项允许您配置图表系列、样式、背景颜色、轴标签、图例等。
要自定义图表,请双击图表并在图表编辑器窗口中选择自定义选项卡。(Customize)
该窗口显示图表样式、轴标题、系列、轴标签、网格线(Chart style, axis titles, series, axis labels, gridlines)等选项,您可以根据要创建的图表类型进行选择。
单击(Click)要配置并应用更改的任何选项。
您在数据和图表编辑器中所做的所有调整都会自动更新,而无需重复整个过程。您甚至无需刷新页面即可反映更改。
希望这可以帮助。(Hope this helps.)
How to automatically generate Charts and Graphs in Google Sheets
Charts and Graphs are a useful tool used for conveying information to clients. Complex numerical data are often presented in the graphical form so that they can be easily understood and remembered. The Graphical representation of data helps to present the information and its developing trends over a period of time in a quick way.
Visual images like charts and graphs also help to highlight the important facts which can be easily remembered and understood. Charts are most often used in business and for daily assignments allowing you to easily see trends and comparisons in a visually appealing way. Whether you want to deliver a presentation to frame a report, charts take an important role in visualizing a complex data analysis to your audience.
Nowadays, Google Sheets is considered a viable alternative to Excel for its online accessibility from any device. Like Excel, Google Sheets includes various features to automate tasks and increase productivity. This web-based application lets you generate charts like any other spreadsheet to convey facts to the audience. It features a wide range of graphs and charts which you can choose for free to convey data in a visually appealing way.
In this article, we explain how to automatically generate charts in Google Sheets.
Generate Charts in Google Sheets
Launch Google Sheets and create a new spreadsheet or open an existing sheet.
Fill the sheets with data into the cells and organize the numerical facts with a column header.
Navigate to Insert and select the option Chart from the drop-down menu. A chart editor window pops up.
Click the option Setup in the chart editor window.
In the Chart type field, select the type of chart you want to create from the drop-down menu. Google Sheets provides 30 variety of charts that you can choose to create for your data.
In the Data range field, select the range of cells that you want to be displayed on the table. You can either choose to manually enter the range or use the pointer to select the data range.
Once the data range is entered, click OK.
Google Sheet will now create and display a chart with all the data selected from the range of cells in the sheet.
Now if you make any changes to the data in the sheets, the chart will be automatically updated with the new results without having to create a new chart for the updated value.
You can also change the type of chart for the same data easily in Google Sheets.
To change the chart type, double click on the chart. This will open a Chart Editor menu.
Go to Setup and in the Chart type field select a new type from the drop-down menu.
Click OK, and the Google Sheet will transform the chart into a new chart style for your data.
Customize charts in Google Sheets
Additionally, Google Sheets allow you to fully customize your charts based on the data. The customizing options allow you to configure the chart series, style, background color, axis labels, legend, and more.
To customize the chart, double click on the chart and select the Customize tab in the chart editor window.
The window displays options like Chart style, axis titles, series, axis labels, gridlines, and many more which you can choose based on the type of chart you want to create.
Click on any options which you want to configure and apply the changes.
All the adjustments you make in data and charts editor are automatically updated without having to repeat the entire process. The changes are reflected without you having to even refresh the page.
Hope this helps.