98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Animating an Excel Chart/Graph
Animating an Excel Chart/Graph
Resolved · Urgent Priority · Version 2003
Thu 8 Oct 2009, 16:04Delegate Ludovic said...
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!
Thu 8 Oct 2009, 17:04Trainer Amanda said...
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
Mon 12 Oct 2009, 11:38Trainer Amanda said...
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
Mon 19 Oct 2009: Automatically marked as resolved.
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
PowerPoint tip:Display pictures inside shapesHere is a suggestion for adding a professional touch to your presentations: displaying pictures within shapes. This can look particularly good if you use pictures within circles or stars. |
