Set chart type, chart area, plot area, X axis, Y axis, series and legend using EasyXLS component! XLSX, XLSM, XLSB, XLS file in VBScript.
https://www.easyxls.com/manual/tutorials/vbs/excel-chart-properties.html