Look Who it Was Random video

Excel - Add New Data to an Existing Chart - Episode 349

332 views · Published 18 November 2009 · 1:55 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Excel Chart Tips: Adding and Removing Data with Drag and Drop Method | MrExcel Podcast.

Welcome back to the MrExcel podcast! I'm Bill Jelen and for the past few weeks, I've been traveling and conducting my Power Excel seminars. One of the best things about these seminars is that I always learn something new from the 150 accountants in the room. So, for the next week, I'll be sharing some tips from my book and also showing you some new and improved ways of performing certain tasks in Excel.

In my book, I shared a great trick for adding new data to a chart. All you have to do is select the new data, including the headings, click on the border, and drag and drop it onto the chart. But what about removing data from a chart? Well, during one of my seminars, someone shared a fantastic tip with me. If you look at the blue outline surrounding the data set, you can click on one of the handles and adjust the chart area. This means you don't have to drag and drop data onto the chart anymore. Instead, you can simply select the chart, grab the area surrounding the data being charted, and use the handles to extend or reduce the charted area.

So, the next time you need to add new data to a chart, just click on the data and drag the blue handle to include more data. It's a quick and easy way to update your chart without having to go through the process of dragging and dropping. Thanks for stopping by and be sure to tune in tomorrow for another helpful tip from MrExcel! Don't forget to like, comment, and subscribe for more Excel tips and tricks. See you soon!

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) Adding new data to a chart
(00:44) Removing data from a chart
(00:56) Using the blue outline to adjust chart area
(01:16) Alternative method for adding data to a chart
(01:35) 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
Adding new data to a chart in Excel
Bill Jelen as Excel expert
Drag and drop data to a chart
Excel chart tricks
Extending or reducing the area being charted
Manipulating the chart area
Power Excel seminars
Selecting the chart
Taking data off of a chart
Tips for working with charts in Excel


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

In Episode 349, learn a cool way to add new data to an existing chart. My book usually shows the drag and drop method to add data, but in Episode 349, you can learn how to drag the selection handle to add or remove data from a chart.

More from this channel