How do I keep my own formatting for a pivot-chart on refreshing

=?Utf-8?B?YmVuc2VsbGFyczEyMTI=?=

Guest

Posts: n/a

13th Jun 2006

I have many pivotcharts which need to be continually refreshed to represent
statistics from data within the workbook. I need to display these charts with
my own colour scheme - however the charts are refreshed they revert back to
the dodgy Excel default colours.

To complicate matters further they are part of a shared workbook - so my
macro I recorded to re-apply my colour scheme doesn't work.

Can anyone help????

« how to auto populate full worksheets | Area between two lines in a chart »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Pivot Chart Problem when Refreshing	=?Utf-8?B?Rmlsbw==?=	Microsoft Excel Programming	1	27th Oct 2007 10:10 PM
Refreshing Pivot Chart	=?Utf-8?B?d2lsbCB0aGUgaW50ZXJu?=	Microsoft Excel Charting	1	16th Jul 2007 08:22 PM
When refreshing pivot tables my pivot table chart type changes	=?Utf-8?B?aGFubmFoMjIwNTA3?=	Microsoft Excel Misc	1	22nd May 2007 02:57 PM
Pivot Charts - refreshing clears my chart formatting	MP	Microsoft Excel Charting	2	3rd Oct 2006 02:18 PM
Refreshing a pivot chart	=?Utf-8?B?TWlrZQ==?=	Microsoft Access Form Coding	1	13th Sep 2006 12:51 PM