Yum, pie! Thanks David. Really, so much help. Since I want all my pies to be color coded so that each part that represents the same value will be in the same colour, I suppose I am going to have to produce a list that includes those pie slices that are 0, so that the positions remain intact. Or maybe it's better to assign colours within the VB itself as I cycle through each pievalue...
thanks again!
