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

Conditional formatting of area chart

B

bwinters

New Member
Hi All,


I have an area chart with dates along the bottom axis and stock price along the vertical axis. I am trying to show 3 distinct "phases" within the area chart by changing the color. Is there a way to have the color of the area change based on the date? I have tried everything I can think of to no avail.


I'm willing to use/learn VBA if thats what is needed. Also I have excel 2010 in case there are any new features in it that will help me.


Any help would be most appreciated.


-Brian
 
There's several tricks you can do, which tankfully don't involve VBA. Check out Jon Peltier's (a charting wizard!) ideas here:

http://peltiertech.com/Excel/Charts/ColoredQuadrantBackground.html


http://peltiertech.com/Excel/Charts/ColoredVerticalBand.html


I think the latter may be exactly what you're looking for.
 
You must log in or register to reply here.
Back
Top