Excel - Efficiently Update Your Excel Charts with New Data | Excel in Depth - Episode 1247
1,436 views · Published 17 September 2010 · 2:14 · Indexed 25 October 2026
Channel: MrExcel.com · 2010 · Education
Microsoft Excel Tutorial: Efficiently Update Your Excel Charts with New Data | Excel in Depth. Welcome back to the MrExcel podcast. In this episode, we will be diving into chapter 32 of Excel in Depth, where we will be discussing how to expand charts. As someone who used to spend hours recreating charts every month, I wish I had known this trick earlier. But don't worry, I'm here to share it with you now. Let's say you have a chart with data for January through March, and you need to add a new data point for April. Instead of creating a whole new chart, simply copy and paste the heading and data onto the existing chart. This works even if the chart and data are on different worksheets. If they happen to be in the same spot, you can use the blue outline to add new data to the right-hand side or even change which data is charted. Another method, which is relatively new, is using tables in Excel. Simply select your data, make sure there is a heading in cell A1, and press [ctrl+T] to define it as a table. Now, when you add a new month of data, it will automatically be included in the chart. This is a great way to save time and avoid constantly recreating charts. So, whether you choose to copy and paste or use tables, there's no need to create your charts from scratch every month. By using these methods, you can easily update your charts with new data and save yourself a lot of time and effort. Thank you for tuning in to this episode of the MrExcel podcast. Don't forget to subscribe and stay tuned for more helpful tips and tricks. See you next time! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Expanding Charts (00:14) Favorite Trick for Creating Charts (00:27) Copy and Paste Method (00:54) Using Blue Outlines to Add or Change Data (01:22) Using Tables in Excel (01:43) Automatically Updating Charts with New Data (01:54) Three Methods for Creating Charts Efficiently (02:04) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Adding new data to a chart Automatically updating charts with new data Blue outline for chart data Copy and paste method for charts Excel in Depth chapter 32 Expanding charts Pivot tables based on tables in Excel Saving time creating charts Using tables in Excel for charts Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152928/ Don't recreate your data field to update your chart in Excel 2010! In Episode #1247, Bill shows (3) methods of adding that new data to an existing chart by simply extending the data field. ..."Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920