Recent content by bertchan2003

Hi RobBroekhuis, That works!!! Thanks.l

Hi RobBroekhuis, To flesh out the problem a bit, on the 3D line chart, I want the x-data from C4:C18, while the Y-data are from F4:F18, F22:F36, F40:F54.... I tried ie, Range("F4:F18,F22:F36").select, but what it gives is a single line composed of these 2 series. Thanks in advance.

Hi RobBroekhuis, It works basically. Because I'll have unknown number of series to be added to the chart (though all the series are in the same column), I'm looking for a smarter way of generating the 3D plot, but have no idea of what the .range has to do with that when I can specify the...

Thanks RobBroekhuis. That bascially works. However, the data series in my excel worksheet are not contiguous, ie the x-series is on C4:C18, the data series (Y values) are in F4:F18, F22:F36, F40:F54....and so on (with a few more data series possibly). So my question is with what to specify on...

Hi lambuhere1, I mean xl3Dline, the 3D line chart in Excel. Thanks

Hi RobBroekhuis, I replaced my code with what you suggested and it works on the first series, but not with the last two. Here is my new code for the subroutine: Sub Create3DChart() Charts.Add ActiveChart.ChartType = xl3DLine ActiveChart.SetSourceData...

Hi, I've recorded a macro for creating a 3D line chart. But whenever I run the macro, it stops at: ActiveChart.SeriesCollection(1).XValues = "=RiskbyFunc!R4C3:R18C3" with this error: Run-time error '1004': Unable to set XValues property of the Series class Any clue? Here is the...

Hi, Does anyone know how to create a 3D line plot using VBA? I'm completely new to using VBA and don't have any clue. Thanks. Bet