Graph Attributes

[sgladie@bgsu.edu]

Access 2013
I have created some graphs on my dashboard. I have parameters set: users can change the data of the graphs by selecting different parameters (fields, combo boxes, frames, etc.) There are four categories (series): In Renovation, Occupied, Out of Service, and Ready to Rent. Each category has its own color: Red, Green, Blue and Yellow, respectively. Here is my dilemma - when a category's value is 0, of course, it doesn't show on the chart, but the chart will "bump up" the colors in order, instead of keeping the color with the category.






For example: Let's say In Renovation has 10 units, colored Red; Occupied has 20 units, colored Green; Out of Service has 0 units, and Ready to Rent has 5 units, it SHOULD be colored Yellow, but since Out of Service is 0, it makes Ready to Rent blue.
Has anyone else every experienced this? I am hoping someone can help me "assign" the colors to the category. Is there VBA to assign the categories (series)?
Appreciate any help given!! I am stumped!!

 

[plog]

Are you sure Out Of Service has 0 units? Null <> 0.

In your underlying data source the graph is built on, do you have a record for Out Of Service and it have a value of 0, or do you not have a record for Out Of Service at all?

 

[sgladie@bgsu.edu]

No record. The query will just list the 3 categories and their value instead of the 4.

 

[plog]

Then you need to make it populate that record with a 0 value.

 

[sgladie@bgsu.edu]

I was afraid you would say that! They need place holders. Thank you for your help!! I'll get on it!!