Hi Andy,

Excel colours are limited to 56 and even that is too much in 1 chart.

FWIW starting in the 57th series a two colour 50% pattern is 'automatically'
applied for the next 56, then a different %grey in the following 56 an so
on. In theory a different 'apparent' colour can be applied in each fill up
to max 255 series. Might want to customize the 10 duplicate colours in a
default palette.

I agree with your point though.

Regards,
Peter T

"Andy Pope" wrote in message
...
Hi,

Quickest way would be via code.

Sub x()

Dim objSeries As Series

With ActiveChart
For Each objSeries In .SeriesCollection
objSeries.Border.LineStyle = xlNone
Next
End With

End Sub

That said a chart with 200 legend entries is not really going to be
readable.
Excel colours are limited to 56 and even that is too much in 1 chart.

Maybe you need to reconsider your chart.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Yossi evenzur" <Yossi wrote in message
...
Hi
In a chart i have multiple legend keys, as a result all colors are not
visible because the columns are thin and border line black, thus i can
see
only black columns. i can format each key manually but if i have 200
keys
it
would never end, how can change the border option from automatic to
none?