Select Pie Chart Slices by Name to recolour

Hi

I've been trying to assign certain colours to Pie Chart slices. The following code does work, however I'd prefer to refer to the slice by name instead of number because the items in the pie chart won't always be in the same order.


This code works:

Please Login or Register  to view this content.

This code does not work, but I want to use a name:

Please Login or Register  to view this content.

The Microsoft help does state that Points(index) is a Variant and a name or number can be used, but if I use a name, I get a "Type Mismatch" error, which tells me that it only wants a number.

Hopefully somebody out there knows a way to achieve this.

Thanks in advance

You can only access the Point collection via a numeric index.

Please Login or Register  to view this content.

I found the solve here: http://www.mrexcel.com/forum/excel-q...nt-colors.html
1) backup datalabels (depth of backup such as text, position, e.t.c. choose yourself)
2) set category name on labels -> obtain point's name
(only datalables we can read, because there are no get property for XValues)
3) coloring point
4) restore datalabels from backup
5) ...
6) PROFIT

UPDATE !!!
application match - is much much better, thanks and sorry for hurrying.
NOte: in powerpoint I use excel.application.match