Change Colors in Excel Pie Chart Programmatically

[Preston5]

I'm trying to change the colors in an Excel pie chart from an Access form. I can build it OK, but the pie slices have to be a specific color. Here's the code I'm trying and it doesn't work at all. I've also tried the MarkerBackgroundColorIndex, but I think it doesn't work with pie charts.

Any help out there with a tough question?

ActiveChart.SeriesCollection(1).Select
ActiveChart.SeriesCollection(1).Points(2).Select
With Selection
.ClearFormats
.Interior.ColorIndex = 37
End With