Animating an Excel Chart/Graph

Resolved · Urgent Priority · Version 2003

Thu 8 Oct 2009, 16:04 Delegate 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:04 Trainer 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:38 Trainer 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 courses

	98.7 % recommend us
	More live stats...

Training information:

PowerPoint tip:

Display pictures inside shapes

Here 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.

To create this effect, draw a shape on your slide from the Drawing toolbar.

Click on the Fill Color button found on the Draw Toolbar usually found at the bottom of the screen; or alternatively right-click on the shape and select 'Format Autoshape'.

Select the Fill Effects option then the Picture tab. Use the 'Select picture' button to find the picture on your computer, then click Insert. Selecting the 'Lock picture aspect ratio' helps to keep the picture in proportion.

View all PowerPoint hints and tips