• 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.

Chart Formating

S

shibulal

Member
I have a line chart which shows the usage against the projected value. Projected value is in green color and the exact value in black. Now, I need the color to be changed automatically from black to red when the exact value exceeds the projected value.
 
Hi shibulal,


Please see does this work for you:


http://dl.dropbox.com/u/60644346/Chart_SplitDataLine.xlsx


Faseeh
 
Hi Faseeh, I failed to understand from the link.

And I fear whether I could explain my request clearly.

It is somewhat like a conditional formatting based on formula.

=If (projected value is <=actual value "line chart color is green),(projected projected value >= Actual value,"line color is RED")
 
hi,


i update faseeh file, please find it below and hope that this is what your looking for,


http://speedy.sh/B5WTz/Copy-of-Chart-SplitDataLine.xlsx
 
You must log in or register to reply here.
Back
Top