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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
MrExcel Excel Videos
Learn Excel from MrExcel - Excel tips and tricks from Bill Jelen.
Today is the 10th anniversary of MrExcel.com, so I am repeating my all-time favorite trick. Episode 895 shows you how.
Rod sends in today's question. He has to export several tab-delimited text files for a third-party application. He has the data for each file on a separate worksheet in a workbook and would like a macro to save those worksheets as individual text files. In Episode 894, I record a simple macro, then edit it to solve Rod's problem.
Eric asks how to customize icons for his macros on the Excel 2007 Quick Access Toolbar. In Episode 893, I will take a look at this feature in Excel 2003 and the limited options available in Excel 2007.
Jon wants to set up validation to see if the result of a calculation exceeds a certain value. In Episode 892, we take a look at using Data Validation with a formula.
You've probably seen the AC/DC video running in an Excel spreadsheet. The author did some cool tricks to deliver the WAV file to your hard drive. In Episode 891, I'll take a look at the code to extract an object from a workbook.
You've probably seen the AC/DC video running in an Excel spreadsheet. The author did some cool tricks to deliver the WAV file to your hard drive. In Episode 891, I'll take a look at the code to extract an object from a workbook.
This blog is the video 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!
You need to do a VLOOKUP that will look up two values from a table. In Episode 889, I will show a method using a concatenated key field to enable VLOOKUP to work.
This video 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!
Rick asks how to set up a chart with two different orders of magnitude. This was a built-in chart type in Excel 2003, but it is harder in Excel 2007. In today's Where Is it Wednesday edition, we will take a look at how to create a chart showing series with different orders of magnitude. Episode 888 shows you how.
