Posted to microsoft.public.excel.charting
|
|
XValues - Why is code1 OK - but code2 doesn't work?
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
|