Here is a sample file with your code in it (and my code as _old). not sure
how to upload it here.....so you may have to create any sample line graph
with 2 data series and 1 trendlines for each data series and then try your
code as well as my code...

I just tested it with your code and it does change the color/width/type of
trendlines but I see a little difference in color of trendlines compared to
data series line. Is it due to I am using 32-bit high resolution on Vista ?

If you then change the colors of data series as well as trendlines manually
to any 4 different colors and then run my macro, the trendlines exactly
change to the colors of the data series lines€¦

really appreciate your help on this.
-satish


"Peter T" wrote:

I don't understand what you are saying, it's contradictory -

"the color assigned to trendline is not exactly same as it's data series
color"
vs
"the RGB was giving me exactly same color as the parent data series line"

If you have standard line type charts with lines in default colours, the
macro I posted should format trendlines with same colour as the "automatic"
colour or the customized colour of the parent series line.

If your charts are not "typical" eg mixed with bar type and line type
series, or has been modified in certain other ways, the macro (as posted)
will give incorrect results

Regards,
Peter T

"satishbhave" wrote in message
...
Thanks Peter, it does work for all trendlines but the color assigned to
trendline is not exactly same as it's data series color. the RGB was
giving
me exactly same color as the parent data series line compared to
COLORINDEX
color...any suggestions ?
-satish

"satishbhave" wrote:

I want to change the trendlines color/type/width to match the data
series
line color. i have this vb code which works well and changes type and
width
but not color. what i found was that to make this work, first, i need to
manually change the color of trendlines and then run the macro.. i don;t
know
if this is a bug or something i am not doing properly