Hi,

Programmatically, how would i refer to the Chart Source data that is in
another Workbook please?

Currently i have:
ActiveChart.SetSourceData
Source:=Workbooks("Cases_Older_Than_One_Year.xls") .Sheets("Charts").Range("A3:" & Mycol & "6"), PlotBy:=xlRows

When Cases_Older_Than_One_Year.xls is open it works fine (as i would expect)
but i would rather not have to have this WB open at this point in the macro.

Thanks

John