Highlighted
Absent Member.
Absent Member.
160 views

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

[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.
0 Likes
1 Reply
Highlighted
Absent Member.
Absent Member.

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

Never mind (again) I found it.
I had to put ChartType first before I could set it to Smooth.

Andre
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.