Please HELP me with changing chart values from a Macro.

What is wrong with this string of code?

Workbooks("HQ Graphs.xls").Sheets("Duration").ChartObjects("Chart " & intKey).SeriesCollection(1).XValues = Workbooks("HQ Graphs.xls").Worksheets("Voice").Range(Workbooks("HQ Graphs.xls").Sheets("Duration").Cells(4, intColumn - intTrend), Workbooks("HQ Graphs.xls").Sheets("Duration").Cells(4, intColumn))


Where:
intKey = 5
intColumn = 17
intTrend = 11

I've check and all of Workbook, Worksheet and Chart references and they exist. I get "Application Defined or Object Defined Error," unless I drop the cell reference in the Range (which I can't do long term as I need that level of dynamism in order for the macro to work). When I use Range("G4:Q4") instead I get "Object does not support this property or method".

Can anyone help?

Please read forum rules below and amend your post

VBA Noob