Excel 2007 Extracting data for charts from multiple worksheets?

[Mechta]

Hi Spurlash2,

Thank you for those links. They have been very informative, although I have still to find a solution to no. 1 (jumping back to the chart worksheet when going to the next column of data).

I'm beginning to think that I am actually at the start of a very steep learning curve with Excel despite having used it off and on for years...