Access graph series color

[Tcurtis]

I have three pic charts for three different facilities containing 6 different possible categories. Each chart contains the exact same information but is filtered by the facility in the chart. Because of this, some facilities will have 0 for a category. This causes the categories to have different colors depending on the amount of categories in the chart. One chart may have blue for catergory 1 while another will have green. How can I, for the lack of a better word, "force" a color for each category even if there is no information there. I have tried Nz to make a category 0 but with so many choices have not been able to make this work. Is there VB code that will force a color to the catergory I desire? Thanks