Thread
:
Unable to set the XValues Property
View Single Post
#
2
Tushar Mehta
Posts: n/a
A good way to do some diagnostic work is to start by figuring out which
line generates the error. Also, compare the old code and the new.
What were the changes?
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,
says...
I am getting a run -time error 1004 stating it is unable to set the XValues
Property of the Series Class. I don't know why!!!
I did some changes to the old code which was running fine but this code is
annoying me .
Can anybody help plz
Sub SelectCapacity()
Sheets("Numerical Integration").ChartObjects("ChartNumInteg").Activa te
ActiveChart.PlotArea.Select
ActiveChart.ChartType = xlXYScatterSmoothNoMarkers
Select Case CapacityCombo.Value
Case "Exponential"
With ActiveChart
.SeriesCollection(1).XValues = "=AnalysisPageNI!R4C1:R100C1"
.SeriesCollection(1).Values = "=AnalysisPageNI!R4C2:R100C2"
.SeriesCollection(1).Name = "Capacity"
End With
Case "Gumbel"
With ActiveChart
.SeriesCollection(1).XValues = "=AnalysisPageNI!R4C1:R100C1"
.SeriesCollection(1).Values = "=AnalysisPageNI!R4C3:R100C3"
.SeriesCollection(1).Name = "Capacity"
End With
End select
End Sub
Reply With Quote