G'day Hong,

Welcome to the Monastery.

""Can't locate object method "add_chart" via package "Spreadsheet::WriteExcel" ". I checked that "add_chart" exists in Workbook.pm" [my emphasis]

It can't find add_chart via WriteExcel.pm, not via Workbook.pm.

So, WriteExcel.pm is where to start your checking.