如果您需要在电子表格中显示动态图表,您可以将数据转换为表格,然后插入图表。在 Excel 中插入动态图表(insert a Dynamic Chart in Excel)很简单,您无需借助第三方软件即可完成工作。
什么是动态图表
动态图表是自动从新单元格中获取数据的图表。当您通过单击Microsoft Excel(Microsoft Excel)中的相应选项插入图表时,它使用固定范围的单元格。换句话说,它不会自动显示新条目,而动态图表可以流畅地显示。
无论您添加多少单元格,即使在插入图表之后,它也会从这些选定的列中收集信息并相应地显示图表。您可以根据需要添加任意多的行,但不建议在Excel中插入动态图表后添加额外的列。
如何在Excel电子表格中插入动态图表(Dynamic Chart)
要在Excel电子表格中插入动态图表(Dynamic Chart),请执行以下步骤 -
- 打开电子表格或创建一个新电子表格。
- 选择(Select)要转换为图表的所有数据。
- 转到插入 > 表格。
- 在创建表(Create Table)窗口中确认范围。
- 再次,选择相同的行和列。
- 转到插入并添加图表。
因此,首先,您需要将数据转换为表格。否则,您的图表将无法识别新数据。
为此,请打开已写入所有数据的电子表格或创建一个新文件。打开后,选择要转换为图表的所有行和列。之后,转到插入(Insert )选项卡并单击表格(Table )按钮。
它将显示单元格的范围,以便您确认。如果您正确选择了数据,您可以单击确定(OK )按钮。它将整个数据转换为表格。如果仍然选择电子表格数据,您可以使用通常的方法插入图表。(insert a chart)但是,如果未选择数据或新创建的表,则需要在前往图表(Charts)部分之前执行此操作。
为了您的信息,您可以添加任何类型的数据图表——条形图(– Bar)、折线(Line)图或面积(Area)图、统计(Statistic)图等。
要确认它是动态图表还是固定(标准)图表,您可以在现有列的底部输入新数据。您的图表应该会自动更新。
我希望这个简单的教程很容易理解。
阅读下一篇:(Read next: )如何在 Excel 和 Google 表格中制作平滑曲线图(How to make a smooth curved graph in Excel and Google Sheets)
How to insert a Dynamic Chart in Excel spreadsheet
If you need to disрlay a dynamic chart in a spreadsheet, you сan convert the data to the table and insert the chart afterward. It is straightforward to insert a Dynamic Chart in Excel, and you do not need to take the help of third-party software to get the job done.
What is a Dynamic Chart
A dynamic chart is such a chart that fetches data from new cells automatically. When you insert a chart by clicking the respective option in Microsoft Excel, it uses a fixed range of cells. In other words, it doesn’t display new entry automatically, whereas a dynamic chart does it fluently.
No matter how many cells you add, even after inserting the chart, it will gather information from those selected columns and show the graph accordingly. You can add as many rows as you want, but it is not recommended to add additional columns after inserting a dynamic chart in Excel.
How to insert a Dynamic Chart in Excel spreadsheet
To insert a Dynamic Chart in an Excel spreadsheet, follow these steps-
- Open the spreadsheet or create a new one.
- Select all the data that you want to convert into a chart.
- Go to Insert > Table.
- Confirm the range in Create Table window.
- Again, select the same rows and columns.
- Go to Insert and add a chart.
So first, you need to convert the data into a table. Otherwise, your chart cannot recognize new data.
For that, open the spreadsheet where all the data in already written or create a new file. After opening, select all rows and columns that you want to convert into a chart. Following that, go to Insert tab and click the Table button.
It will show the range of cells so that you can confirm. If you select the data correctly, you can click the OK button. It will transform the whole data into a table. If the spreadsheet data is still selected, you can insert a chart using the usual method. However, if the data or newly created table is not selected, you need to do that before heading to the Charts section.
For your information, you can add any kind of chart with the data – Bar chart, Line or Area chart, Statistic chart, etc.
To confirm where it is a dynamic chart or a fixed (standard) chart, you can enter new data at the bottom of existing columns. Your graph should be updated automatically.
I hope this simple tutorial was easy to follow.
Read next: How to make a smooth curved graph in Excel and Google Sheets