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