How To Move Chart To New Window in Excel

Here is a trick for those of you working with Excel on a daily basis, especially if you are spending a significant amount of time with charts. Charts are a great way to visualize data and how data manipulation might have an affect on the overall picture.

The issue that I ran into with my setup is the Chart that requires a large screen real estate, so it has to occupy the full sheet. However, the downside with a full sheet of charts is the consistent back and forth editing between the data and the charts. It would ideal if there is a way to have the Charts open side by side with the original data so the visualization can occur in real time while data manipulation is being applied.

Fix By Move Chart Into a new Window

The fix is actually quite simple, if you have a Chart that’s a representation of either your existing Sheet or from a different Sheet of the same document you can move the ONLY the chart to a separate window while maintaining the link and data integrity between the data and the chart.

2015-12-23_1614

Right Click on the Chart (sheet) > Move or Copy … 

2015-12-23_1615

From the Move or Copy popup dialogue ensure to move this to a different Book, it can be a new book or any existing Book. This way you will keep the data integrity from the original document and the new Excel worksheet as long as both are open.

Jonathan Hu

Programming by day, Web Development, Canucks & Movies for spare time!
Co-founder of Next of Windows and a cool geek 🙂

Last updated: 11/29/2016

Posted in: How to , Office
Discover more: , ,