Hui - thanks for the welcome and for your advice. The data won't always be able to be in the same sequence. I'll check into saving a Custom Chart type. Thanks for your help.
Various information on the same set of organizations. I understand pie charts are best for a few data elements, not many. Even if I switch to bar charts I'll still be looking to do the same - have each organization represented by just one color in all the charts.
I have a workbook with several pie charts in it. Each chart has the same data labels as the other charts but different data in it. The order of the data labels changes from chart to chart. I need to keep the color the same for each data label in all the pie charts. Does anyone know how I can...