formatting of multiple lines on a chart

Hi, I have an ordinary Excel line chart, but there are 30 data series on it. Is there a quick way to format each line the same, eg blue with no individual data points.

thanks

Hi,

Format 1 line as required and then select the next and use F4 to apply
the same formatting.
You can use the up/down arrows to cycle through the data series.

Cheers
Andy

robert111 wrote:
> Hi, I have an ordinary Excel line chart, but there are 30 data series on
> it. Is there a quick way to format each line the same, eg blue with no
> individual data points.
>
> thanks
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info