Create charts that automatically update data in Excel 2016

A chart in Excel can show more information than words. The difficulty in processing data and charts is that you will often have to change the data regularly and also have to update the chart based on the new data.

Access Microsoft Excel Online

Download Microsoft Excel for iOS

Download Microsoft Excel for Android

In this article, Download.com.vn will help you eliminate this problem by creating automatically updated charts . All you have to do is add data to the spreadsheet and the chart will automatically update with the newly added data. Let's get started.

1. Set up a spreadsheet

To create an auto-update chart, you first need to set up a worksheet that can apply the data you request. The format of this document is important because you will need to be able to add more data on an ongoing basis.

Create a spreadsheet with information and make sure each column has a title. For example, the following article tracks the consumption of each volume of Harry Potter stories in the store.

Create charts that automatically update data in Excel 2016

The type of chart we are creating works best if you can expand new entries into the new rows below. In this example, new consumption data has been recorded, you will add it to the worksheet from row 11.

Create charts that automatically update data in Excel 2016

2. Create a table

In Office 2016 , tables have been enhanced. Instead of just making your data look neat and tidy, they help you group information together. The ultimate goal here is to create a table that provides data for the chart. Linking these two elements allows the chart to check for newly added data in the table.

To create a table, you select all the data you want to turn into a chart. Then click on the tab Insert and select Table , or you can use the keyboard shortcut Ctrl + T .

Create charts that automatically update data in Excel 2016

In the Create Table dialog box , you can refine the cells included in the table. Check the box labeled My table has headers , and click OK .

Create charts that automatically update data in Excel 2016

Your data will undergo the following appearance changes:

Create charts that automatically update data in Excel 2016

3. Create a chart and add data

Select the entire table and go to Insert> Chart to select the type of chart you want to use. The exact chart will depend on the type of data you are working on. This example is using a line chart. This allows comparing many different columns with data values ​​in a chart and it works very well with automatic updates.

Create charts that automatically update data in Excel 2016

Now is a good time to make any format changes or tweak the interface. Once done, you can check the new data added to the chart. Next, you need to check if the auto-update chart is actually working.

To add more data, simply add another line below the existing chart. Since the Date column specifies the values ​​on the X-axis of the chart, we'll start from there. Formatting dates (Date) can be quite confusing, so you drag the lower right corner of the cell down to automatically move the cell.

Create charts that automatically update data in Excel 2016

You will probably see a warning dialog box that inserts the row into the worksheet, which is fine. Your chart will be updated to include new entries on its X axis. Assuming that is true, you are safe to start adding new data to the table.

Create charts that automatically update data in Excel 2016

Above you can see that the last day sales for every story are 10 and the chart has been updated according to that data. You can now use charts indefinitely, simply by adding multiple rows to the table. However, you may need to adjust the size and format to display all data properly, depending on the amount you plan to add.

Sign up and earn $1000 a day ⋙

Leave a Comment

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel

How to fix the error of printing blank pages in Microsoft Excel. Why do some Excel documents not display data or contain blank pages when printed? Below are the reasons

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar

How to pin Word, Excel and PowerPoint files to the corresponding app icon on the Windows 11 taskbar, How to pin Office files to the taskbar icon on Windows 11? Invite

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save Excel files on Windows

How to fix the error of not being able to save an Excel file on Windows. If you can't save the Excel file, don't worry too much. Below are ways to fix the error of not being able to save the above Excel file

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel

How to insert a picture into a cell using VBA in Excel, You can easily insert pictures into Excel spreadsheets and edit them with macro code. Here's how to insert images

How to enable auto-capitalization of the first letter of a sentence in Excel

How to enable auto-capitalization of the first letter of a sentence in Excel

How to enable auto-capitalization of the first letter of a sentence in Excel, Turning on the automatic-capitalization of the first letter of a sentence in Excel will save you a lot

How to calculate seniority work on Excel spreadsheets

How to calculate seniority work on Excel spreadsheets

Through this tutorial, WebTech360 will guide you how to calculate the seniority of a list of employees in the company via Microsoft Excel spreadsheet or WPS Spreadsheets.

IF and IFS functions in Excel: Usage and specific examples

IF and IFS functions in Excel: Usage and specific examples

The IF function in Microsoft Excel is one of the most commonly used logical functions. In the simplest sense, the IF function will return a result based on one or several input comparison data.

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Learn Excel - Lesson 6: How to filter unique values ​​and delete duplicate values ​​in Excel

Filtering unique values ​​and deleting duplicate data is a basic operation that everyone needs to know when using Excel. Join us to learn how to do it in Excel!

How to use VLOOKUP, INDEX, ... in Excel you should know

How to use VLOOKUP, INDEX, ... in Excel you should know

The functions VLOOKUP, INDEX, MATCH, ... are quite complex functions but are effective in data mining in Excel. In this article, I will guide you in detail how to use VLOOKUP and related functions effectively.

Instructions for deleting horizontal lines in Word

Instructions for deleting horizontal lines in Word

Word, an indispensable tool for office workers when editing documents and editing documents to create professionally presented and arranged documents, Word often comes with Excel and PowerPoint in the Microsoft Office suite, caters to many types

Learning Excel - Lesson 11: Importing and exporting text files

Learning Excel - Lesson 11: Importing and exporting text files

There are two simple ways to import data from a text file (.txt or .csv) into Excel. To export data from Excel to a text file, use the Save As command and change the file type from the drop-down menu.

What is the difference between Excel and OpenOffice?

What is the difference between Excel and OpenOffice?

OpenOffice is an office suite built on open source. Like Excel, this toolkit can be used on computer systems using Windows or Linux operating systems.

How to insert a PDF file into Excel

How to insert a PDF file into Excel

Adding PDF files to Excel will make working with this spreadsheet tool much more efficient and professional.

Instructions for sending emails from Excel spreadsheets using VBA scripts

Instructions for sending emails from Excel spreadsheets using VBA scripts

Using VBA scripts in Excel does not require any programming knowledge. VBA helps you do many advanced tasks such as creating a spreadsheet report containing all PC information, emailing directly from a spreadsheet ...

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Zooper Widget for Android 2.36 - Latest Version Updates for 2024 and 2025

Discover the latest updates in Zooper Widget for Android. Zooper Widget is a compact, highly customizable, and battery-friendly widget with endless possibilities.

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS 4.4 - Make lip sync and voiceover videos on iPhone / iPad 2024, 2025

Lipp for iOS, alongside Dubsmash and Musical.ly, provides iPhone and iPad users with a new platform to create lip sync videos and dub videos readily.

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

How to Share Audio with TeamViewer - Latest Version Updates 2024, 2025

Learn how to share audio using TeamViewer, including the latest updates for 2024 and 2025, making remote communication more effective.

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Adorable Home: Latest Tips for Petting Your Cat in 2024 and 2025

Learn the latest tips on how to pet a cat in Adorable Home for optimal gameplay in 2024 and 2025. Discover what positions give you hearts.

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

OrangeHRM Open Source 3.2.1 - Latest Features for 2024 and Beyond

Explore the latest features of OrangeHRM Open Source, a free HR management system tailored to meet evolving business needs in 2024 and 2025.

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

How to Fix IDM Error Not Catching Download Links - Updates for 2024 and 2025

Fix IDM not catching file download links. Discover solutions for downloading videos, music, and more with the latest IDM updates in 2024 and 2025.

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

The File Converter for Android - Convert files to other formats - Updated Versions 2024, 2025

Discover the latest version of The File Converter for Android, an application that converts various file formats efficiently.

Updated Zalo Web Login Features for 2024-2025

Updated Zalo Web Login Features for 2024-2025

Explore the latest features of Zalo Web, allowing users to chat and connect seamlessly on various browsers without installation.

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover 6.0 - The Ultimate Solution for Password Removal in PDF Files

PDF Password Remover is a powerful tool for removing passwords and restrictions from PDF files. Download the latest version for 2024 to experience enhanced features.

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Latest Instructions for Completely Removing Internet Download Manager (IDM) - Updated for 2024 and 2025

Step-by-step instructions to completely remove Internet Download Manager (IDM) from your system in 2024 and 2025. Learn to uninstall IDM effectively and cleanly.

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Mindjet MindManager 2024 & 2025 - Empower Your Mind Mapping

Discover Mindjet MindManager, an innovative software that helps individuals and teams streamline their work processes through effective mind mapping and project management.

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su Doku 2.0.0 - Latest Updates 2024 & 2025

Su DoKu 2.0.0 is an advanced Sudoku game design software that captivates enthusiasts with its simplicity and functionality. Download now and challenge yourself with Sudoku puzzles.

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Google Photos for Android - Unlimited Photo and Video Storage with Latest Features in 2024, 2025

Discover the new features of Google Photos for Android in 2024 and 2025, including faster backup and advanced search capabilities.

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Updated IQmango DVD Ripper 2024 - New Features and Enhancements

Discover the latest version of IQmango DVD Ripper in 2024, a powerful software to easily rip, copy, convert, and back up DVDs.

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet - Tools to Arrange Group Meetings (Updated 2024, 2025)

When2meet is an easy-to-use group meeting scheduling tool for organizing collaborative meetings. Discover the latest features of When2meet for 2024 and 2025.