XValues - Why is code1 OK - but code2 doesn't work?

[tskogstrom]

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]

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]

Thank you, your guess was correct - it work ok now.

Thanks again,
tskogstrom



Andy Pope skrev:

 

[tskogstrom]

I recently got a similar error, but the problem was that the reference
area of the chart was hidden rows and columns.

Seems like charts demand visible cells...hope this help someone more
....This might have been the reason to this tread question also.

/Regards
tskogstrom