Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
change color of curve line as time changes
You will need two series. Suppose dates are in A2:A100, values to plot in
B2:B100 In C1 use =IF(A1<=TODAY(),B2,NA()) In D1 use =IF(A1TODAY(),B2,NA()) Copy both down their columns Quickest way is to select all data and make your chart, then delete the line in the cart for column B (or use CTRL to select A, C and D) Visit Jon Peltier and look at his 'conditional chart' material http://peltiertech.com/Excel/Charts/...nalChart1.html best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "cliffordjf" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
change color of curve line as time changes
Excel 2007, PivotTable, PivotChart
Three colors, one series. With Macro. http://c0444202.cdn.cloudfiles.racks...12_29_09b.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I change the color of ONE line on the y-axis in a chart? | Charts and Charting in Excel | |||
How to change color of line and point markers on a line graph | Charts and Charting in Excel | |||
Can you change the color of only one axis line? | Charts and Charting in Excel | |||
Make a line in a bar chart, and change color of any bars that exceed the line | Excel Discussion (Misc queries) | |||
watch a curve change over time like a movie | Charts and Charting in Excel |