If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 news 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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|