Pivot table chart - turn off automatic color

G

Guest

Hi All,
I have a chart that contains several input created through a pivot table.
For making my chart clear I decided to apply 3 colors for my inputs some are
green, some are yellow and some are red.
But after each refresh, I get the default colors coming back.
How can I remove this default color setting and save my color choice ?
thanks for your replys
Denis
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Chart Refresh cancels all chart formatting 2
how to change color gradients in a bar chart 0
Pivot Chart 1
Color gradient problem on X-Y chart 2
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
Limits of Pivot chart 1
How do I lock the colours in a chart (red, amber, green) 2
Pivot Table Chart - Group Totals 1

Top