• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Help needed

J

Jagadeeshbs

Member
Hi all

I have simple line chart in which i have data from jan-10 to dec-12 now i need to change the color of the line form future period to red. who can i do this ..?

form jan-10 till data the color of the line should be green and form dec-11 to dec-12 should be red.

Thank you very much for the help
 
Hi,

Probably the easiest way to solve your problem is to use two series of data in additional columns. Lets say you have dates in column A and values in column B. In column C use formula
Code: 
=IF($A2<=TODAY(),$B2,NA()) and in column D use =IF($A2>=TODAY(),$B2,NA())
. Then use columns C and D as source of series of your chart.
 
magbo


Your formula works very well but i need the table as attached.


https://docs.google.com/spreadsheet/ccc?key=0AoWaaVJwF8R_dEdRRlFDeVR5WmlTRTktTlVtcFJIaHc#gid=0


thank you

Jagadeesh
 
You must log in or register to reply here.
Back
Top