Chart colours

Hi All,   Is it possible to use categorical variables such as (Colour/Department) etc.. to colour the simple bar and column charts)? For e.g. if i have a sales by product chart, and each product b...