Set the stacked bar chart colors to automatic in Excel

In 2010 when you select your chart you will see a Chart Tools toolbar being highlighted, under the Design tab is Chart Styles with the 2nd style (I think) being the default one. (To get it done by macro, record one while selecting the style)