I'm afriad this is the MS Excel Chart forum. You might get more help by
posting in the Access Reports forum.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Gary" wrote:

I have a Pie Chart with 2 items only (R or P). R is a dark color and P is a
light color. When There isn't any P in my data, the chart picks the light
color for R.

I would like to always have a dark color for R and a light color or P.

I am doing the chart in MS Access 2000-03 and my row source is:

SELECT [RP],Sum([Freq]) AS [SumOfFreq] FROM [Rept#704_Joint_RP] GROUP BY
[RP];

Can someone please help me.


Thanks,

Gary