Ludovic has attended:
Excel Intermediate course
Animating an Excel Chart/Graph
I have an excel chart; a bar chart combined with (trend)lines.
Its in my powepoint presentation(pp). As its fairly complex, it would be really nice to animate it.
I have in powerpoint as a chart, as opposed to a picture.
I have managed to ungroup the data points in the chart in pp. The trouble is:
I want the first chunk of the series of bars to appear first. I click control on this series to animate this first. It appears, but as the rest of the chart was never got rid of, so does the rest of the chart.. I tried having an exit strategy for the chart before it comes in, but can't do this - there are too many data points to select them all and have them all disappear.
There must be another way?
Ideally, I'm after the first chunk of bar series to come in, followed by a trendline above it, then a next chunk of bar to go on top of the original series, and a second trendline above that, x5.
Help, advice, tips, all very much appreciated.
Thanks!
RE: Animating an Excel Chart/Graph
Hello Ludovic
Thank you for your question.
Would you be able to email a copy of the graph in Ppt and we'll see what we can do?
Email address is amanda@stl-training.co.uk
If the presentation file is quite big, could you please just send the slide with the graph on it? Thanks.
Kind regards
Amanda
RE: Animating an Excel Chart/Graph
Hello Ludovic
Thank you for sending your files through.
I tried applying an entrance effect to the chart using Custom Animation, then going into Effect Options (using the small dropdown arrow next to the effect in the Custom Animation panel on the right hand side of the screen), then going to the Chart Animation tab and changing the option to Series.
This does animate the chart series by series, however it does not then give you the option to re-order the animation of each series in the way that you would like the parts of the chart to appear.
The only thing I can think that might achieve what you would ideally like, would be to create 5 separate charts that could be overlaid one over the other to create the desired effect.
Kind regards
Amanda
