Microsoft Office 2007/2010 comes with the new office themes
tabs.
Charts require 6 colours to be setup and then Excel uses
this to generate charts with all 6 colours and shades thereof or as shades of
one of those 6 colours.
Most clients will setup their themes without taking into
account Excel Charts or the new data bars features.
In other words they’ll set the first or 2nd
colour or even totally miss the 6 ones required altogether.
Themes need to be stamped per workbook otherwise they start
with the standard out of the box office theme.
Most clients have between 2 to 4 main colours that their branding
guys have supplied. What this means is that you have to create other colours or
repeat the given colours to prevent non-corporate colours from being used.
In the rare cases where clients supply 7 colours, you just
use 6.
Creating the other colours is a tricky process. Some colour
wheels allow you to provide 3 colours and they’ll give you 3 blended ones.
e.g. Blue and Yellow blend to make a green colour.
This link provides a nice example
Regards,
Tom Bizannes
Excel Developer Sydney Australia
###