Thread: formatting of multiple lines on a chart
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default formatting of multiple lines on a chart
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
Reply With QuoteReply With Quote