Look Who it Was Random video

Excel - Excel Charts with Data from Different Sheets - Excel Trick Revealed! - Episode 897

737 views · Published 5 January 2009 · 1:43 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial - Excel Charts with Data from Different Sheets - Excel Trick Revealed!

Welcome to another MrExcel netcast! In this video, I'll be sharing a cool trick that I learned at one of my recent seminars in Virginia. It's all about pasting data onto a chart in Excel, and it's a game-changer for those who work with charts regularly.

As you may already know, in Excel 2003, you can simply drag and drop new data onto a chart to update it. In Excel 2007, you can use the blue outline to achieve the same result. But what if your chart and data are not on the same worksheet? That's where this third method comes in handy.

Let's say we have a chart sheet with data for January, February, March, and April. Now, we have new data for May in a separate worksheet. Instead of manually updating the chart, we can simply copy the data (including the heading) using Ctrl+C and then paste it onto the chart using Ctrl+V. This trick works just like dragging and dropping, making it a quick and efficient way to update charts with data from different sheets.

So there you have it, a simple yet powerful trick to paste data onto a chart in Excel. I hope you found this tip helpful and will use it to save time and effort in your chart-making process. Don't forget to subscribe to our channel for more Excel tips and tricks, and I'll see you in the next netcast from MrExcel!"

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/

While I've shown how to drag and drop data on a chart, that method doesn't work if your chart is on a different worksheet than the data. Today in Episode 897, a trick to add new data to an existing chart.

Table of Contents:
(00:00) Introduction
(00:22) Drag and drop data onto chart
(00:31) Using blue outline in Excel 2007
(00:43) Alternative method for charts on different sheets
(00:53) Third way to add data to chart
(01:01) Copy and paste method
(01:11) Quick way to add data to chart
(01:21) 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 existing chart in Excel
Copying data to Excel chart
Ctrl+C and Ctrl+V for Excel chart data
Excel chart blue outline
Excel chart data manipulation
Excel chart data update
Excel chart drag and drop data
Excel chart sheet
Excel chart tricks
Excel tips and tricks
Updating chart with data from different sheet


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

More from this channel