Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
robert111
 
Posts: n/a
Default 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


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=547012

  #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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I display multiple series in a pie chart? AncientPC Charts and Charting in Excel 3 May 3rd 23 05:09 PM
Line chart with multiple scales/units along an axis... JohanD Charts and Charting in Excel 3 March 19th 06 04:53 AM
Line chart from multiple worksheets Paul B. Charts and Charting in Excel 2 September 21st 05 11:46 PM
Pie chart with 'anchored' lines to text box TOMB Charts and Charting in Excel 0 May 4th 05 09:14 PM


All times are GMT +1. The time now is 08:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"