Hi,

You can only select a single data series but you could use a macro.
Here's a sample one with a couple of format options

Sub FormatChart()
Dim r As Series
For Each r In ActiveChart.SeriesCollection
r.Border.Weight = xlThin
r.Shadow = True
Next
End Sub


Mike

"KRK" wrote:

Hello,

I know how to format a data series in a chart. I right-click on the data in
the chart, select 'format data series, no problem.

I want to format several series at the same time (eg line thickness, marker
colour). Is there a way of doing this ??

Thanks

KK

.