| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem error when creating a chart in VBA
Hello,
What would cause the following line... ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3" to produce an error number 1004? Thanks Keith |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem error when creating a chart in VBA
Replace the chartname in the below
Charts("Chartname").SeriesCollection(1).XValues = Worksheets("Sheet1").Range("C3:C44") -- If this post helps click Yes --------------- Jacob Skaria "keith" wrote: Hello, What would cause the following line... ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3" to produce an error number 1004? Thanks Keith |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem error when creating a chart in VBA
HI Jacob,
Thanks very much. Keith "Jacob Skaria" wrote: Replace the chartname in the below Charts("Chartname").SeriesCollection(1).XValues = Worksheets("Sheet1").Range("C3:C44") -- If this post helps click Yes --------------- Jacob Skaria "keith" wrote: Hello, What would cause the following line... ActiveChart.SeriesCollection(1).XValues = "=Sheet1!$R4$C3:$R44$C3" to produce an error number 1004? Thanks Keith |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error Creating Chart | Excel Programming | |||
| Problem with empty cells when creating chart using vba | Charts and Charting in Excel | |||
| Problem with creating chart within existing worksheet. | Excel Programming | |||
| Creating Second Chart via Sub Procedure Error | Excel Programming | |||
| Creating Second Chart via Sub Procedure Error | Excel Programming | |||
Linear Mode
