i need multiple graphs from multiple spreadsheet to appear once i clicked on the macro buttons . And do i need to do pivot table first to generate the respective graphs? please advice.

EXAMPLE OF chart in userform 4.xlsmEXAMPLE OF chart in userform 4.xlsm