The ODS ExcelXP tagset does not support graphic images and only creates a Microsoft Excel XML Spreadsheet file.
The ODS Excel destination supports graphic images and creates Microsoft XLSX files. This paper shows an example of a chart and table in the same worksheet:
New for SAS® 9.4: Including Text and Graphics in Your Microsoft Excel Workbooks, Part 2 https://support.sas.com/resources/papers/proceedings17/SAS0127-2017.pdf
What error do you get when you run the code in VA? Can you post the SAS log?
Vince DelGobbo
SAS R&D
... View more