First got the Ribbon and under Animations. From Animations section choose Custom Animation. Apply an animation of your choice and from the drop down menu choose “Effect Options”. From the new window choose Chart Animation tab and choose from the drop down list either By Series or By Category.