How do I: If Pie Section Label = X, Make Pie Section Color = Y
 

A question for any of the Masters of Excel out there,

How do I go through all the data labels in a Pie Chart, look for a specific
label text, then change the pie slice color based on what the label says?

The reason for this excercise is that the order of the data may change but I
want to make the pie slice colors consistant over several charts where the
data order may change.

Thanks!
MikeZz

How do I: If Pie Section Label = X, Make Pie Section Color = Y
 

This VBA routine will do it:

http://peltiertech.com/WordPress/200...ategory-label/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MikeZz" wrote in message
...
A question for any of the Masters of Excel out there,

How do I go through all the data labels in a Pie Chart, look for a
specific
label text, then change the pie slice color based on what the label says?

The reason for this excercise is that the order of the data may change but
I
want to make the pie slice colors consistant over several charts where the
data order may change.

Thanks!
MikeZz

How do I: If Pie Section Label = X, Make Pie Section Color =
 

Looks pretty slick! Can't wait to try it.

Thanks,

"Jon Peltier" wrote:

This VBA routine will do it:

http://peltiertech.com/WordPress/200...ategory-label/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"MikeZz" wrote in message
...
A question for any of the Masters of Excel out there,

How do I go through all the data labels in a Pie Chart, look for a
specific
label text, then change the pie slice color based on what the label says?

The reason for this excercise is that the order of the data may change but
I
want to make the pie slice colors consistant over several charts where the
data order may change.

Thanks!
MikeZz