How do I color specific data series based on location on data she

[Havard]

I have about 150 data series in a chart and I want to color e.g. 10 of them
red based on where in the data sheet they are located, e.g. data i column J
to T. Is there an easy way to do this?

[Barb Reinhardt]

Format one of them the way you want. Select the other series you want to
change and press F4. This may be difficult with 150 series, however.

"Havard" <Havard@discussions.microsoft.com> wrote in message
news:8F62297E-447B-4507-8D4A-A2C9A38C08EA@microsoft.com...
> I have about 150 data series in a chart and I want to color e.g. 10 of
them
> red based on where in the data sheet they are located, e.g. data i column
J
> to T. Is there an easy way to do this?