| 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 |
| 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) | |||
Threaded Mode
