Skip to main content

[archive] need some help translatig vb to excel (again)

  • February 26, 2007
  • 1 reply
  • 0 views

[Migrated content. Thread originally posted on 26 February 2007]

I want to make a chart line smooth. I got the translation of the vb code.
However excel says it cannot set the smooth property.The shadow property works fine. They are both booleans.
What am I doing wrong?

Andre

With Selection
.MarkerBackgroundColorIndex = xlAutomatic
.MarkerForegroundColorIndex = xlAutomatic
.MarkerStyle = xlAutomatic
.Smooth = True
.MarkerSize = 5
.Shadow = True
End With

77 var-dispatch HANDLE.
77 w-var-series HANDLE OF @Series.
77 w-var-source USAGE HANDLE.
77 h-seriescollection HANDLE OF @SeriesCollection.

modify oChart @SeriesCollection()
returning h-seriescollection
modify h-seriescollection @Item(1)
returning w-var-series
modify w-var-series @Shadow = 1,
@Smooth = 1.

1 reply

[Migrated content. Thread originally posted on 26 February 2007]

I want to make a chart line smooth. I got the translation of the vb code.
However excel says it cannot set the smooth property.The shadow property works fine. They are both booleans.
What am I doing wrong?

Andre

With Selection
.MarkerBackgroundColorIndex = xlAutomatic
.MarkerForegroundColorIndex = xlAutomatic
.MarkerStyle = xlAutomatic
.Smooth = True
.MarkerSize = 5
.Shadow = True
End With

77 var-dispatch HANDLE.
77 w-var-series HANDLE OF @Series.
77 w-var-source USAGE HANDLE.
77 h-seriescollection HANDLE OF @SeriesCollection.

modify oChart @SeriesCollection()
returning h-seriescollection
modify h-seriescollection @Item(1)
returning w-var-series
modify w-var-series @Shadow = 1,
@Smooth = 1.
Never mind (again) I found it.
I had to put ChartType first before I could set it to Smooth.

Andre