I reproduced issue with a new file:
Excel file with Chart on a New Sheet: test1.xlsx (11.3 KB)
Thanks.