- moritz nölting
- PowerBuilder
- Monday, 19 February 2018 09:07 AM UTC
hi,
i'm creating an excel-sheet with an chart, no problem so far. im also creating a chart in it and i want to change the default color for the legend-objects.
the problem is that i found no way how it works, maybe anyone can help me?
lole_app.ActiveChart.Legend.Select
lole_app.ActiveChart.Legend.LegendEntries(1).Select
lole_app.Selection.Format.Line.ForeColor.RGB = RGB(0, 176, 80)
lole_app.Selection.Format.Fill.ForeColor.RGB = RGB(0, 176, 80)
the error is that line can't be accessed, but in the excel-macro and documentation it is line or fill...
thanks
moritz
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.