formatting of multiple lines on a chart

[robert111]

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]

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