Pie Chart Color Slices Macro

[coreyjames]

I am having trouble creating a macro that will automatically match the color slices with the name of a slice from a previous graph. I work in health care and there are over 2000 procedures so I cannot setup the pie slices to change color based on name. If I have Graph A which Excel automatically colors the pie slices can I get graph B to match graph A's slice colors based off of the names? I hope I am explaining this well. Thanks!

 

[coreyjames]

If anyone could help me out with this it would be greatly appreciated. Thank you!