change color of curve line as time changes
in [Charts]
|
Prev: How do I add category labels in a chart but keep series separate?
Next: Data in secondary axis dizappears when using names
From: cliffordjf on 7 Dec 2009 19:00 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
From: Bernard Liengme on 8 Dec 2009 21:11 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(A1>TODAY(),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/ConditionalChart1.html best wishes -- Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "cliffordjf" <cliffordjf(a)discussions.microsoft.com> wrote in message news:D667E7EE-30DA-4CA2-AF3E-3A221CFF9D60(a)microsoft.com... >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
From: Herbert Seidenberg on 30 Dec 2009 00:28
Excel 2007, PivotTable, PivotChart Three colors, one series. With Macro. http://c0444202.cdn.cloudfiles.rackspacecloud.com/12_29_09b.xlsm |