Chart Legend Colors

A

Alla

I have 6 (max) pre-set categories that are shown on pie chart. I need each
category to have certain color always - even if there is no data for some of
them. For example - category "home" should be always blue, even if it doesn't
exist for certain month (it should be skipped). Currently Access skips the
category (if there are no data) and assigns blue to the next category. How
can I pre-set colors?
Thanks in advance, Alla
 
Top