Conditional Formatting on composite graphs

Hi,

I would love to be able to do conditional formatting on graphs with multiple levels (for example with legends applied).

And with related fields.

Say if a graph is showing various "Products" produced, but I want the related column "Department" to decide wich colour each product will have.

I would also love to have a filter for a related field decide and switch between colours on a different graph.

Say we have the "Products" graph again, but all departments produce the same products. I want the products graph to switch to the corresponding colour when I filter the data for each department.

//Sigrid