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
-------------------------------
tskogstrom skrev:
Thank you, your guess was correct - it work ok now.
Thanks again,
tskogstrom
Andy Pope skrev:
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