Click OK. The chart will open on a chart sheet. How to move the chart to a different Excel sheet in the same workbook Before doing this, have more than one worksheet tab open.

Step-by-step tutorial on creating an analytical dashboard in Excel that updates automatically using a pre-designed template or from scratch.

However, Microsoft Excel grants you the convenient option in Chart Tools to move this chart to a new sheet, which also enlarges it for easier viewing.

It's time to dump the pie charts and move to donuts or even waterfalls to show off your data in ways people can better grasp.

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them.