I am creating a chart and adding trendlines via VBA - which is all working
marvellously.

Each series is assigned a colour automatically. What I'd like to achieve is
to set the related trendline to be a darker version of the line colour.
However I can't see a way of finding the colour assigned to the series (which
are set as xlAutomatic by Excel)

Is this possible? Or will I have to manage the colours of the series and
trends myself?

I recorded a macro while manually changing the trend line color. this is
what I got.

Sub Macro1()
'
' Macro1 Macro
' Macro recorded 10/18/2007 by Joel
'

'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).Trendlines(1).Select
ActiveChart.SeriesCollection(1).Trendlines(1).Select
With Selection.Border
.ColorIndex = 4
.Weight = xlMedium
.LineStyle = xlContinuous
End With
End Sub


"DuncanL" wrote:

> I am creating a chart and adding trendlines via VBA - which is all working
> marvellously.
>
> Each series is assigned a colour automatically. What I'd like to achieve is
> to set the related trendline to be a darker version of the line colour.
> However I can't see a way of finding the colour assigned to the series (which
> are set as xlAutomatic by Excel)
>
> Is this possible? Or will I have to manage the colours of the series and
> trends myself?

> I recorded a macro while manually changing the trend line color. this is
> what I got.

Thanks for the help, but I know how to change the colours; the question
is how to find out the actual colour assigned to a series that has its
ColorIndex property set as xlAutomatic. I could then use that information to
calculate a darker colour and assign that to the associated trendline colour.

I've gone for manually assigning known colours to the series and trendlines,
from an array that I have set up initially, so it's now more of a question
out of curiosity, but it would be nice to know.