Pivot Table Formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

p-town_office - 24 Oct 2006 00:34 GMT

I am trying to customize the format of both a pivot table and pivot chart
(color, line width, etc.) and have the format remain upon refreshing the
data. Basically, I want to make this custom color design the default
formatting for tables and charts. Does anyone know if this is possible?
Also, can you customize color options as well? For example, if my color
table doesn't have a brown, can I add brown to the format color options?

Reply to this Message

Debra Dalgleish - 24 Oct 2006 01:00 GMT

You can create a custom chart type, and set it as the default. However,
if you change or refresh the pivot table or chart, some of the
formatting may be lost. You could then reapply the custom chart type,
manually or programmatically.

To customize the colours, choose Tools>Options, Color tab. The chart
colours are at the bottom of the dialog box, and those colours will be
used as defaults when the chart is refreshed.

> I am trying to customize the format of both a pivot table and pivot chart
> (color, line width, etc.) and have the format remain upon refreshing the
> data. Basically, I want to make this custom color design the default
> formatting for tables and charts. Does anyone know if this is possible?
> Also, can you customize color options as well? For example, if my color
> table doesn't have a brown, can I add brown to the format color options?

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message