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.

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.