Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
LKP LKP is offline
external usenet poster
 
Posts: 19
Default Varying colors on a line chart with multiple series

In Excel 2003, is it possible to change the color of part of a line on a
chart with multiple data series? I can do it on a single series chart.
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 2,489
Default Varying colors on a line chart with multiple series

Hi,

Yes, you would need to select the segment of the line and then format it.
So select the series
pause and then select the segment
apply formatting

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"LKP" wrote in message
...
In Excel 2003, is it possible to change the color of part of a line on a
chart with multiple data series? I can do it on a single series chart.


  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Varying colors on a line chart with multiple series

You can click once to select a whole series, then again to select a single
point or a single line segment. After selecting just one segment, go to
Format menu Selected XXX.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"LKP" wrote in message
...
In Excel 2003, is it possible to change the color of part of a line on a
chart with multiple data series? I can do it on a single series chart.



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
Show average line by series on a line chart Judy Rose Charts and Charting in Excel 1 August 28th 08 04:42 PM
Cutting a line in a line chart when data series stops DannyS Charts and Charting in Excel 2 August 28th 07 10:38 AM
Line chart, multiple series, data is inter-mixed Bob[_5_] Charts and Charting in Excel 2 April 27th 07 07:13 PM
regarding allocation of chart series point colors David Charts and Charting in Excel 2 October 27th 06 09:18 AM
Line chart colors T Charts and Charting in Excel 0 April 15th 06 12:55 PM


All times are GMT +1. The time now is 08:51 PM.

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"