You can change the entire palette or only the colors used in MS Excel to paint charts. In this option you will find the Rotation Tools. Inside this you have:

Chart Color: Rotate between all the graphic palettes and see the changes in your charts' appearance with each palette.

Point: Use this tool to change interactively the color of each point in a series or the different slices of a pie chart using the different colors in the active graphic palette.

Series: Use this tool to change interactively the color of each series of a bar chart using the different colors in the active graphic palette. Click the button "Sample" to view samples and to practice using the rotation tools.

Apply your Favorite Palette: Use it to change your Favorite Palette.

For accessing to this tool you should go to SP General Tools/General Tools Settings
and choosing Select Palette tab, in the displayed window.