formatting of multiple lines on a chart

  • Thread starter Thread starter robert111
  • Start date Start date
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
 
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
 
Back
Top