This is really about using an excel chart inside an access report but nobody
in microsoft.access.reports seems to know the answer.

Using a grouped field in a database I end up with two values per record
showing the number of 'goods' and the number of 'bads' The pie chart plots
these two numbers. I want the 'good' slice always to be green and the 'bad'
slice always to be red.

Setting the format worked OK until I had 7 goods and zero bads, then the
whole chart was red instead of green.

Any idea how I can fix this?

Howard