Changing MS Graph object color palette

R

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
 
Top