I found this can't be done.

My work around I inserted a table beside the chart. With the same group names and color coded the same. A little header a...

Alvin,

Thanks I put the unit count lookup clause in the iif statement, not just referencing the count.

I resolved the issue by rewriting my queries with case statements.