Re: Reset the colors in a chart
- From: "Peter T" <peter_t@discussions>
- Date: Wed, 20 Aug 2008 17:38:12 +0100
You could customize the automatic colours as used by default in charts.
Tools, Options, Colors
look at colours starting in the 6th row and compare with default (non
formatted) colours in your pivot charts
After customizing the palette to your needs hopefully you won't need to
apply your own colour formats.
Keep in mind the palette belongs to and is saved with the workbook. Perhaps
make a template with your customized palette and other common features for
your pivots.
Regards,
Peter T
"JanHDon" <JanHDon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:129F8F55-5641-40D8-AE2F-F4334D5C08A9@xxxxxxxxxxxxxxxx
I have a series of pivot table charts--one for all employees, and
individual
ones. I want to give the projects the same color legend across all the
charts. I've tried changing the legends, one-by-one, then saving the
chart,
then moving to the next iteration, but when I go back to the first chart,
the
colors have returned to the defaults. What am I missing?
.
- References:
- Reset the colors in a chart
- From: JanHDon
- Reset the colors in a chart
- Prev by Date: Re: Reset the colors in a chart
- Next by Date: RE: How do I set up title rows to fit large sentences?
- Previous by thread: Re: Reset the colors in a chart
- Index(es):
Relevant Pages
|
