Hi,

An educated guess would be that the assignment can not deal with
multiple areas.

Try this instead, where each element is fully described.

cht.SeriesCollection(1).XValues = "=('" & _
Sheet2.Name & "'!" & _
Sheet2.Range("nme1").Address(True, True, xlR1C1) & _
",'" & Sheet2.Name & "'!" & _
Sheet2.Range("nme2").Address(True, True, xlR1C1) & _
",'" & Sheet2.Name & "'!" & _
Sheet2.Range("nme3").Address(True, True, xlR1C1) & ")"

Cheers
Andy

tskogstrom wrote:
Hi, I have a xlColumnClustered chart of three bars only, with values
and names picked from cells not besie eachother. The first working code
is based on recording, but I can't have RC reference in my code.

The second code, I get "Unable to set the XValues property of the
Series class" 1004 runtime error.

Why doesn't the second work?

'cht.SeriesCollection(1).XValues = _
' "=(Report!R6C7,Report!R6C4,Report!R3C17)"

cht.SeriesCollection(1).XValues = Union(Sheet2.Range("nme1"),
Sheet2.Range("nme2"), _ Sheet2.Range("nme3"))

Kind regards
tskogstrom


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info