Changing MS Graph object color palette

[Randall Arnold]

I'm using the MS Graph object in an Access report. The client requires 6
custom colors for the bars, but the bars are limited to the same 56-color
palette that Excel suffers from and those colors aren't in it. I know it's
possible to modify the palette in Excel, but, using VBA, how do I modify the
one used by the MS Graph object?

Thanks in advance for all assistance,

Randall Arnold