Can I create a chart using data from two worksheets or workbooks?
J Jon Peltier Sep 29, 2008 #2 Probably. See this article for details: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon
Probably. See this article for details: http://peltiertech.com/Excel/ChartsHowTo/ChartFromDiffSheets.html - Jon
B Bernard Liengme Sep 29, 2008 #3 It is best to have the data in one place. But that place can reference other worksheets as in =Sheet3!B4 =[JumpTwo.xls]Sheet1!$L$3 best wishes
It is best to have the data in one place. But that place can reference other worksheets as in =Sheet3!B4 =[JumpTwo.xls]Sheet1!$L$3 best wishes
