LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6,582
Default Changing pivot chart format

You could change the defaults in the color palette, which changes the
defaults for everything.

Microsoft suggests recording a macro one time when you fix the pivot chart
formatting, so you can rerun the macro next time.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"J.W. Aldridge" wrote in message
oups.com...
thanx....



is there any way to stop the default from changing the colors back
after I've adjusted them?



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Duplicating Pivot Chart / Changing Pivot Chart data range BillG Excel Discussion (Misc queries) 4 February 25th 10 02:15 PM
How do I keep my pivot tables format from changing? AndrewEdmunds Excel Discussion (Misc queries) 5 October 28th 08 02:53 PM
Prevent user changing pivot chart layout Jessica Excel Worksheet Functions 0 April 15th 06 12:24 AM
Maintain colour changes in a Pivot Chart when changing Pivot value rdickfos Charts and Charting in Excel 1 April 11th 06 09:05 AM
Changing Default Chart Format Saurjusa Charts and Charting in Excel 2 November 24th 05 08:26 PM


All times are GMT +1. The time now is 01:56 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"