Chart Source Data

[Mark.B]

Is it possible to set the source data of a chart to an external reference / workbook. I have tried the following but to no avail:

Activechart.SetSourceData Source:=Workbooks(Filepath\WorkbookName.xls).Sheets ("Data").Range ("A1:Z1"), PlotBy:= xlrows

Can anyone help ?

 

[SteveO59L]

Why do you need to do this with code?. Wouldnt it be easier to use the chart properties?.

 

[Mark.B]

I need the chart to be dynamic e.g. the source data changes (programatically) when an item from a dropdown list is selected.

 

[SteveO59L]

Done something like this before. I think it involved using a vlookup based on the result from your list box.