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

Watch on YouTube

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