| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I make a section break in Excel | Excel Worksheet Functions | |||
| How do I print just the section a through f only? | New Users to Excel | |||
| How do I make a section sort automatically? | Excel Discussion (Misc queries) | |||
| How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
| How do I make a section of a chart line dotted? | Charts and Charting in Excel | |||
Linear Mode
