How to change the slice color of a pie chart in the older version of Excel

Hello everybody,

I have an annoying problems with Excel versions. I have Excel 2007 on my workstation, but I'm editing an old Ms Access Database who are calling an old version of Excel. I want to select the colors from my SeriesCollection, but the code I have seen for newer version isn't working for me in my old database. It's working well in Excel 2007 :

How can I do the same thigs as the following code in Excel 2002 ?

Please Login or Register  to view this content.

I've seen other examples, but so far none are working. I'll continue to search a solution.

Thank you !

Please Login or Register  to view this content.

I must do something like that,but the DataLabel does not work, how can I see the name of the point ?

An other update, I was able to do the following code and it's working well with pie charts :

Thanks to Andy Pope for the tip he made in an other thread.

Please Login or Register  to view this content.

This is working fine, but when I add anything else in my sub it stop working. I don't understand.

Now, I must do the same thing with line charts but my solution is not working and I still don't understand :

Please Login or Register  to view this content.

This is weird because it does not made any error.