Graph/Pie Chart Coloring

[dannylam4]

Hello I have an issue with Access I was hoping someone could help me on. So I have this pie chart graph with 3 sections, colored red for East, Green for West, and Blue for North. Now the problem is that sometimes, the data that I pull in doesn't have a "West" and therefor doesn't add it to the chart. This, however, throws the coloring scheme off as it assigns colors so that 1 is red, 2 is green, 3 is blue rather than East is red, West if Green, and North is Blue. I'll provide some images so it'll be easier to understand. (Clickable thumbnails)

 

[ted.martin]

Not really used this but Access has its vagaries. Perhaps you could assign west with a very small figure like 0.1 if the real figure is zero; maybe that will fool the little critter.

 

[dannylam4]

I was thinking of that, forcing the value to be .1 if it was actually 0, but I don't know how to do the VB code to force it like that.

 

[ted.martin]

In the table - try putting the 0.1 as the default value.