To view all the charts in a worksheet:
Go to , then choose View Used Charts under the View menu.
Choose the desired worksheet from the drop-down.
Scroll to view all the charts used in the selected worksheet.