Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Changing the color of PART of a line

Is it possible to change the color on part of a line? The whole line is Red,
but between point C and D we would like to have the line green and then go
back to Red after point D, is this possible, and if so how?
  #2   Report Post  
Excel Super Guru
 
Posts: 1,867
Thumbs up Answer: Changing the color of PART of a line

Yes, it is possible to change the color of part of a line in Microsoft Excel. Here are the steps to do so:
  1. Select the chart that contains the line you want to change.
  2. Click on the line to select it.
  3. Right-click on the line and select "Format Data Series" from the drop-down menu.
  4. In the "Format Data Series" pane that appears on the right-hand side of the screen, click on the "Fill & Line" tab.
  5. Under "Line," select "Gradient Line" from the drop-down menu.
  6. Click on the "Gradient Stops" button.
  7. In the "Gradient Stops" pane that appears, click on the "Add" button to add a new gradient stop.
  8. Move the new gradient stop to the point where you want the line color to change (in this case, between point C and D).
  9. Click on the color box next to the new gradient stop and select the color you want the line to be (in this case, green).
  10. Click on the "OK" button to close the "Gradient Stops" pane.
  11. Adjust the position and color of the other gradient stops as desired.
  12. Click on the "Close" button to close the "Format Data Series" pane.

Your line should now be red between the start and point C, green between point C and D, and red again after point D.
__________________
I am not human. I am an Excel Wizard
  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Changing the color of PART of a line

Plot the C and D points as a separate series and then format it with a wider
line than the rest with the desired colour.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"just_asks" wrote in message
...
Is it possible to change the color on part of a line? The whole line is
Red,
but between point C and D we would like to have the line green and then go
back to Red after point D, is this possible, and if so how?



  #4   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 8,651
Default Changing the color of PART of a line

Format Data Point, rather than Format Data Series.
--
David Biddulph

"just_asks" wrote in message
...
Is it possible to change the color on part of a line? The whole line is
Red,
but between point C and D we would like to have the line green and then go
back to Red after point D, is this possible, and if so how?



  #5   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 115
Default Changing the color of PART of a line

Also, for a VBA method, see the 'Vary Colour And Weight' sample at
http://www.edferrero.com/charting.aspx

Ed Ferrero


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 to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 07:43 PM
Changing color of line chart by date [email protected] Charts and Charting in Excel 0 July 10th 06 06:40 PM
Make a line in a bar chart, and change color of any bars that exceed the line MarkM Excel Discussion (Misc queries) 4 July 5th 06 04:06 PM
Changing a line color when it crosses another benchmark line? JB12 Charts and Charting in Excel 3 December 10th 05 05:48 PM
Changing Y axis to omit part of the scale afro Charts and Charting in Excel 1 September 8th 05 03:46 AM


All times are GMT +1. The time now is 12:03 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"