LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 3
Default change color of curve line as time changes

I have a series of values associated with dates; the values in the past are
fact, the values in the future are estimates. When I graph the data, the
line is all the same color throughout the series. Is there a way to have the
color of the line change as the dates become past, rather than future....

in other words, the line is black through todays data, but turns to red from
tomorrow on, then as tomorrows comes, that part of the line turns from red to
black...

thanx

cjf
 
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 do I change the color of ONE line on the y-axis in a chart? Merna Charts and Charting in Excel 1 March 25th 08 04:58 PM
How to change color of line and point markers on a line graph SASPerson Charts and Charting in Excel 1 November 15th 06 06:43 PM
Can you change the color of only one axis line? Jim Moberg Charts and Charting in Excel 1 October 21st 06 01:45 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
watch a curve change over time like a movie RandyBarrett Charts and Charting in Excel 6 February 19th 05 05:00 AM


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