Bar of Pie Charts Exel 2010

**Andy Pope** · 07-11-2011, 09:12 AM

Not a default setting that I know of.

Can you post example of a workbook where you can not change the Other's slice.

**heymeliss** · 07-11-2011, 10:15 AM

Here's one. I would like to change the other slice to blue, but right clicking and trying to format data point to change the fill color doesn't work. Thanks for your help with this.

**Andy Pope** · 07-11-2011, 10:28 AM

Looks like this might be a bug in the Pivot chart object.

When I select Solid fill the focus in the dialog is automatically moved to the Automatic fill option.

And it does not look like you can code around it.

Edit: The is a long winded way around it. Set all of the chart to the colour you want the Others slice. Then set the colour of all the other slices.