 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / July 2005chart default colors
Are there any other suggestions for changing the default charting colors when a pivot chart is made? I am frustrated by changing the colors on one chart, only to have them change back to defaults when the chart is switched. Please help. If it's just the colors, go to Tools menu > Options > Colors, and adjust the bottom two rows of colors. You could also format a chart, save it into a user defined type, then reapply it to a refreshed pivot chart: http://peltiertech.com/Excel/ChartsHowTo/CreateCustomTypes.html - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ > Are there any other suggestions for changing the default charting colors when > a pivot chart is made? I am frustrated by changing the colors on one chart, > only to have them change back to defaults when the chart is switched. Please > help. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.