how do you make it so a chart in 'sheet10' is based on aggregated data in sheet 1-9? OR based on data from another .xlsx file?

i found http://spreadsheetpage.com/index.php...le_chart_sheet but these are separate, disaggregated charts...