--- description: If each worksheet in an Excel workbook contains several charts and now you would like to batch move all charts to a new created worksheet, you can refer to this post. Here we will introduce you 2 easy ways. title: 2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook image: https://www.datanumen.com/blogs/wp-content/uploads/2018/06/move-chart.jpg --- - - - [Home](https://www.datanumen.com/blogs/) > [Solutions](https://www.datanumen.com/blogs/category/solutions/) > [Office Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/) > [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) > 2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook # 2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook [Excel Solutions](https://www.datanumen.com/blogs/category/solutions/office-solutions/excel-solutions/) September 28, 2025 Share Now: - - - - - - - - *If each worksheet in an Excel workbook contains several charts and now you would like to batch move all charts to a new created worksheet, you can refer to this post. Here we will introduce you 2 easy ways.* After creating charts for the data in each worksheet of an Excel workbook, so as to better analyze data according to these charts, you may want to gather all these charts to a same worksheet. In other words, you may hope to move all of them to a new worksheet. If there are few charts, you can just use the following Method 1 to move one by one. Yet, if there are a myriad of charts, you are better off utilizing the latter one. ## Method 1: Manually Move Chart One by One 1. At first, create a new worksheet where you want to move all charts. 2. Then, open a worksheet and pitch on a chart in it. 3. Next, right click on the chart and select “Move Chart” from the context menu.![Move Chart](https://www.datanumen.com/blogs/wp-content/uploads/2018/06/move-chart.jpg "Move Chart") 4. In the popup “Move Chart” dialog box, select the new sheet in “Object in” list and click “OK”.![Select Location]( "Select Location") 5. At once, the selected chart will be moved.![Chart Is Moved to New Sheet]( "Chart Is Moved to New Sheet") 6. Now, you can use this way to process all the charts in all worksheets one by one. ## Method 2: Batch Move with Excel VBA 1. To begin with, launch Excel VBA editor according to “ [How to Run VBA Code in Your Excel](https://www.datanumen.com/blogs/how-to-run-vba-code-in-your-excel/)“. 2. Then, put the following code into a module or project. ``` Sub MoveAllCharts() Dim strNewSheet As String Dim objTargetWorksheet As Worksheet Dim objWorksheet As Worksheet Dim objChart As Object 'Create a new sheet strNewSheet = "Charts" ActiveWorkbook.Worksheets.Add(Before:=Application.Worksheets(1)).Name = strNewSheet Set objTargetWorksheet = Application.Worksheets(strNewSheet) For Each objWorksheet In Application.ActiveWorkbook.Worksheets If objWorksheet.Name <> strNewSheet Then 'Move each chart to the new sheet one by one For Each objChart In objWorksheet.ChartObjects objChart.Chart.Location xlLocationAsObject, strNewSheet Next objChart End If Next objTargetWorksheet.Activate End Sub ``` ![VBA Code - Batch Move All Charts from All Exiting Worksheets to a New Created One]( "VBA Code - Batch Move All Charts from All Exiting Worksheets to a New Created One") 3. Afterwards, directly press “F5” to run this macro right now. 4. When macro finishes, exit VBA editor. 5. In Excel main window, you can see a new worksheet, in which you can see all the charts.![Batch Moved Charts in the New Excel Worksheet]( "Batch Moved Charts in the New Excel Worksheet") ## Comparison | ** ** | **Advantages** | **Disadvantages** | | --- | --- | --- | | **Method 1** | Easy to operate | You have to move one by one | | **Method 2** | Can process all charts in bulk | Users have to beware of external macros | ## Repair Damaged Excel File Excel file is prone to corruption since Excel can crash now and then. Under such a circumstance, you’d better prepare a powerful and trustworthy [xlsx recovery](https://www.datanumen.com/excel-repair/) tool, such as DataNumen Excel Repair. It will come in handy when your Excel file gets corrupted and Excel’s auto-recovery feature doesn’t work. ## Author Introduction: Shirley Zhang is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including [repair sql](https://www.datanumen.com/sql-recovery/) and outlook repair software products. For more information visit [www.datanumen.com](https://www.datanumen.com/) Share Now: - - - - - - - - [← Previous post](https://www.datanumen.com/blogs/how-to-batch-convert-attach-multiple-word-documents-as-pdf-files-to-an-outlook-email/) [Next post →](https://www.datanumen.com/blogs/6-easy-steps-to-fix-the-issue-that-restoring-itunes-backup-takes-very-long-time/) Comments are closed. ![Data Recovery Blog]() Follow or like us on Facebook, LinkedIn and Twitter to get all promotions, latest news and updates on our products and company. - - - ### Featured Products - [DataNumen Outlook Repair](https://www.datanumen.com/outlook-repair/) - [DataNumen SQL Recovery](https://www.datanumen.com/sql-recovery/) - [DataNumen Exchange Recovery](https://www.datanumen.com/exchange-recovery/) - [DataNumen Access Repair](https://www.datanumen.com/access-repair/) - [DataNumen Excel Repair](https://www.datanumen.com/excel-repair/) - [DataNumen PDF Repair](https://www.datanumen.com/pdf-repair/) - [DataNumen Word Repair](https://www.datanumen.com/word-repair/) - [DataNumen Zip Repair](https://www.datanumen.com/zip-repair/) ### Popular posts ```json {"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#article","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/"},"author":{"name":"AuthorCCW","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957"},"headline":"2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook","datePublished":"2018-06-08T01:34:13+00:00","dateModified":"2025-09-28T14:15:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/"},"wordCount":414,"commentCount":1,"publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/move-chart.jpg","articleSection":["Excel Solutions"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/","url":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/","name":"2 Ways to Batch Move All Charts from All Existing Worksheets to a New Created One in Excel Workbook","isPartOf":{"@id":"https:\/\/www.datanumen.com\/blogs\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#primaryimage"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#primaryimage"},"thumbnailUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/move-chart.jpg","datePublished":"2018-06-08T01:34:13+00:00","dateModified":"2025-09-28T14:15:00+00:00","description":"If each worksheet in an Excel workbook contains several charts and now you would like to batch move all charts to a new created worksheet, you can refer to this post. Here we will introduce you 2 easy ways.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/2-ways-to-batch-move-all-charts-from-all-existing-worksheets-to-a-new-created-one-in-excel-workbook\/#primaryimage","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/move-chart.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2018\/06\/move-chart.jpg","width":803,"height":438,"caption":"Move Chart"},{"@type":"WebSite","@id":"https:\/\/www.datanumen.com\/blogs\/#website","url":"https:\/\/www.datanumen.com\/blogs\/","name":"Data Recovery Blog","description":"Discuss every aspect of data recovery","publisher":{"@id":"https:\/\/www.datanumen.com\/blogs\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.datanumen.com\/blogs\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.datanumen.com\/blogs\/#organization","name":"Data Recovery Blog","url":"https:\/\/www.datanumen.com\/blogs\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/","url":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","contentUrl":"https:\/\/www.datanumen.com\/blogs\/wp-content\/uploads\/2019\/02\/logowithouttext.jpg","width":296,"height":397,"caption":"Data Recovery Blog"},"image":{"@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/DataNumen","https:\/\/x.com\/DataNumen","http:\/\/www.linkedin.com\/company\/datanumen","https:\/\/myspace.com\/datanumen\/","http:\/\/www.pinterest.com\/datanumen\/","https:\/\/www.youtube.com\/channel\/UCVIIuuKfUBHSJauUaVP13tw"]},{"@type":"Person","@id":"https:\/\/www.datanumen.com\/blogs\/#\/schema\/person\/33ded6c47c77587f9158d99f05e23957","name":"AuthorCCW","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/3516ed90fc242780d3947a989f895bc46e70c3e83485d30f2b457a007906aa58?s=96&d=mm&r=g","caption":"AuthorCCW"},"sameAs":["https:\/\/www.datanumen.com\/"]}]} ```