formatting of multiple lines on a chart

R

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
 
A

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
 
Top