• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

Default Colors in Microsoft Office Excel Chart OLE Objects

I am using a Powerpoint 2007 add-in that works specifically with Microsoft Office Excel Chart OLE Objects ("Insert > Object > Microsoft Office Excel Chart"). I have setup a custom color pallet in both PowerPoint and Excel that is used as the default in new PPT and XLS files. However, when I insert a Microsoft Office Excel Chart OLE Object into a PowerPoint file, this custom color pallet is not used as the default. Instead, the colors revert back to the "Office" pallet. Does anyone know why these embedded objects don't use the color pallet that I have defined in the "XLSTART\book.xltx" template? Even better, does anyone know how I get the default color pallet to be anything other than "Office" for these embedded Microsoft Office Excel Chart OLE Objects?
0
ff13056
Asked:
ff13056
1 Solution
 
Rory ArchibaldCommented:
Try creating a chart with the colours you want in Excel, then save it as a template (Design tab in Chart Tools), then click the change chart type button, select the templates option, choose your chart and press the Set as default button. That should set the default for new charts in Powerpoint too.
0
 
ff13056Author Commented:
I'll have to do some more extensive testing, but all of my initial tests are holding up. It looks like this might solve my issue. Thank you, rorya!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now