I have build a pivot chart and define each bars by colors. But each time I
select and run another page field, the colors I set before change to other
colors.

I'd save my work every each and then, but still it cannot help me.

Can anyone help me on this.

Thank You.

This loss of custom formatting is an admitted issue in pivot charts.

You could :
(a) record and replay a macro to reformat the pivot chart as needed.
(b) define a custom chart type and reapply it when needed.
(c) make a regular chart from the pivot data, with dynamic ranges to reflect
changing series lengths.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
774-275-0064
208-485-0691 fax

http://PeltierTech.com/
_______


"Dayana Rawi" <Dayana wrote in message
...
I have build a pivot chart and define each bars by colors. But each time I
select and run another page field, the colors I set before change to other
colors.

I'd save my work every each and then, but still it cannot help me.

Can anyone help me on this.

Thank You.