Charts in SSRS can be configured to use custom colour palettes. I quite liked the colour scheme used by default in Excel 2007 charts, so I used an eyedropper tool to work out the colour codes it used. Here are the first 16:
#40699C
#9E413E
#7F9A48
#695185
#3C8DA3
#CC7B38
#4F81BD
#C0504D
#9BBB59
#8064A2
#4BACC6
#F79646
#AABAD7
#D9AAA9
#C6D6AC
#BAB0C9
#40699C
#9E413E
#7F9A48
#695185
#3C8DA3
#CC7B38
#4F81BD
#C0504D
#9BBB59
#8064A2
#4BACC6
#F79646
#AABAD7
#D9AAA9
#C6D6AC
#BAB0C9
You can replace a chart's palette in BIDS by viewing the XML code of your RDL, searching for the <Palette> tag and replacing it with the following code:
<Palette>Custom</Palette>
<ChartCustomPaletteColors>
<ChartCustomPaletteColor>#40699c</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#9e413e</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#7f9a48</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#695185</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#3c8da3</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#cc7b38</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#4f81bd</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#c0504d</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#9bbb59</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#8064a2</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#4bacc6</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#f79646</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#aabad7</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#d9aaa9</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#c6d6ac</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#bab0c9</ChartCustomPaletteColor>
</ChartCustomPaletteColors>
<Palette>Custom</Palette>
<ChartCustomPaletteColors>
<ChartCustomPaletteColor>#40699c</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#9e413e</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#7f9a48</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#695185</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#3c8da3</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#cc7b38</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#4f81bd</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#c0504d</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#9bbb59</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#8064a2</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#4bacc6</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#f79646</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#aabad7</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#d9aaa9</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#c6d6ac</ChartCustomPaletteColor>
<ChartCustomPaletteColor>#bab0c9</ChartCustomPaletteColor>
</ChartCustomPaletteColors>