pivotPie.xlsx

<div>
It will retain the original format but if you change the colors from what it produces that is when the problem seems to occur
</div>


It will retain the original format but if you change the colors from what it produces that is when the problem seems to occur

<div>
Well I tried it again and it worked I do not know what the problem was in the past but thanks
</div>


Well I tried it again and it worked I do not know what the problem was in the past but thanks

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I am creating a pie chart from a pivot table and every time I change a filter the format of the pie chart changes. (ie the colors of the pie change) &nbsp;I want to be able to maintain the formatting. &nbsp; I need for the slices to remain Red Yellow And Green. &nbsp;<br />
<br />
Thanks, <br />
Montrof
</div>
</div>


Hi Experts,

I am creating a pie chart from a pivot table and every time I change a filter the format of the pie chart changes. (ie the colors of the pie change)  I want to be able to maintain the formatting.   I need for the slices to remain Red Yellow And Green.  

Thanks, 
Montrof

Excel 2013 Pivot Chart

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.