I am not sure how to go about using two worksheets for one chart. I have tried using the wizard and it tells me that the reference is invalid. Here is what I have so far ='Averages - 04'!&b&46:&cw&46+'Averages - 05'!&b&46:&d&46. Any help would be gratefully appreciated.

Thanks