Excel 2003 Color on Pivot Chart

T

Ty

In Excel 2003 I do the following:

Format Data Series

Pattern Tab->Area->None
Select my color
Hit OK

Everything is fine.

The problem is when I right click my pivot info and select the "!" for
REFRESH.

PROBLEM:
Color changes back

Is there a way to keep the selected color?

Thanks in advance..
 

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

how to change color gradients in a bar chart 0
Pivot charts formatting 1
making chart element changes that persist 1
Change gradient color in chart for Excel 2007 5
Changing/Manipulating Legend range for a Pivot Chart in XL2010 vsXL2003 and below. 0
How to control Bar colors for Pivot Chart 2
How to let pivot table chart's format stay after refreshing data. 2
Excel 2007 Chart - determining the color of a chart style 1

Top