Скачать или смотреть Excel - Have Your Excel Charts Expand As You Enter New Data - Episode 994

Microsoft Excel Tutorial: Have Your Excel Charts Expand As You Enter New Data
Welcome back to the MrExcel netcast! In today's video, we're going to continue our discussion on dynamic charting. In our previous video, we talked about using a dynamic named range to automatically expand our chart as we add new data. But did you know that there's another method available in Excel 2003 and 2007? That's right, we can use the List function in 2003 or the Table function in 2007 to achieve the same result.

Let's take a look at how this works. First, we'll start with a large amount of data that we want to analyze. To do this, we'll fire up a pivot table. But what if we want to see this data in a chart that automatically updates as we add new data? Well, we can do that by setting up a table using either the List or Table function. In Excel 2003, we use Control+L and in 2007, we use Control+T. This will create a table with headers, making it easier to work with our data.

Now, here's the amazing part - as we add new data to the right side of the table, our chart will automatically update! This is because the chart is based on the table, so any changes we make to the table will be reflected in the chart. This eliminates the need for using dynamic named ranges and makes the process much simpler. So, if you're using Excel 2003 or 2007, this is definitely a method worth trying out.

I want to give a special thanks to Alex for sending in the question that inspired this video. And as always, thank you for stopping by the MrExcel netcast. We hope this video was helpful and we'll see you next time for another netcast. Don't forget to like and subscribe for more Excel tips and tricks!

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-...

Table of Contents:
(00:00) Introduction to the MrExcel netcast
(00:10) Challenge: Solving a problem with dynamic named ranges
(00:20) Using a dynamic named range to expand a chart
(00:30) Alternative method using the List or Table function
(01:05) Defining a table with headers for automatic updates
(01:34) Recap of methods for expanding a chart
(01:46) 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:
Creating a table with headers in Excel 2003/2007
How to automatically expand a chart in Excel as new data is typed
MrExcel netcast on chart expansion techniques
Setting up a table for automatic chart updates in Excel
Solving chart expansion problem in Excel using tables
Updating a chart automatically with new data in Excel 2003/2007
Using control+L to create a table in Excel 2003
Using control+T to create a table in Excel 2007
Using dynamic named ranges in Excel 2002 for chart expansion
Using the List function in Excel 2003 for chart expansion
Using the Table function in Excel 2007 for chart expansion
YouTube video on analyzing large data with pivot tables

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads...



In Episode 994, another solution to Ally's problem of how to make a chart expand when you type new data in the worksheet. Today's method shows an easier way to set up a dynamic chart range in Excel 2003 and newer.

This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!