Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
XValues - Why is code1 OK - but code2 doesn't work?
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
XValues - Why is code1 OK - but code2 doesn't work?
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 |
#3
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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
XValues - Why is code1 OK - but code2 doesn't work?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Recomended Graphing Programs to work with excel? | Charts and Charting in Excel | |||
A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
Moving a sheet from one work book to another? | Excel Worksheet Functions | |||
My links no longer work . . . | Excel Discussion (Misc queries) | |||
Work Rota - Do I need a formula? | Excel Discussion (Misc queries) |