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.