Recently while drawing graphs for my research results, i came across problem of drawing confidence interval graphs and excel sheet references from other documents.

For confidence interval graphs --> i watched two you tube videos whose link i have posted earlier.

For fetching data from different excel workbook sheet to current one, i used referencing approach...

=[pathto workbook]sheetno!cellnumber