David Lean (SQL Server Technology Specialist at Microsoft Australia for many years) began a highly informative SQL Server blog last year - "Dave Does Data": http://blogs.msdn.com/davidlean
In a monster post today, Dave documents the techniques he uses to colour Charts (& Tables) in Reporting Services. It's a fairly comprehensive guide. ~54 screen pages over 4 posts that will help anyone trying to look as good as Dave does with SSRS reports!
http://blogs.msdn.com/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-1-4-the-basics-report-expressions-custom-code.aspx http://blogs.msdn.com/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-2-4-functions-for-tables-charts.aspx http://blogs.msdn.com/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-3-4-tint-shade-functions.aspx http://blogs.msdn.com/davidlean/archive/2009/01/30/sql-reporting-how-to-color-coding-based-on-data-values-for-tables-charts-1-n.aspx
Please pass the word along..