animating excel chartgraph
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training add this page to your favourites/bookmarksBookmark page

view a printable version of this pagePrintable version
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Powerpoint Training and help » Animating an Excel Chart/Graph

Animating an Excel Chart/Graph

The UK's most regular instructor-led training courses.
Training information: powerpoint/training/in · Powerpoint training · Microsoft PowerPoint Training UK
See also · powerpoint training · powerpoint.course · powerpoint advanced

resolvedResolved · Urgent Priority · Version 2003

No ranking yet
6 posts
replyReplyThu 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!

Powerpoint Intermediate Advanced 1 day course
Version Date Location Places
available
Book Next place rate (£)
Pay by
Card
Pay by
Invoice
2007 Fri 26 Mar 2010 Bloomsbury 3 Book now £235 £240
2003 Fri 26 Mar 2010 Southwark 0 FULL    
2003 Mon 29 Mar 2010 Bloomsbury 3 Book now £235 £240
2007 Thu 1 Apr 2010 Limehouse 4 Book now £224 £225
2007 Tue 13 Apr 2010 Bloomsbury 9 Book now £182 £187
2007 Fri 16 Apr 2010 Limehouse 6 Book now £212 £217
Full Schedule: See all 28 Powerpoint Intermediate Advanced course dates.
Bookings currently available until 16th December 2010.

Diamond
2,024 posts
replyReplyThu 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

If the presentation file is quite big, could you please just send the slide with the graph on it? Thanks.


Kind regards
Amanda

Diamond
2,024 posts
replyReplyMon 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.


Related articles

· Need To Make A Key Presentation? Get Smart!
· Using Multimedia in PowerPoint Presentations
· SmartArt - Never Lost in Translation
· Ensuring Your Presentation Is Decent, Honest - And Legal
· How To Create A PowerPoint Slide Show To Run Without PowerPoint

Please browse our web site to find out more about
powerpoint/training/in and other Microsoft training courses.

Powerpoint tip:

To display the Start menu

To display the Start menu: press WINDOws button (next to Alt)

View all Powerpoint hints and tips


Rate this page:
2.1/5 (108 votes cast)
Institute of IT Training - Accredited Training Provider ILM
Microsoft Certified Partner
Microsoft Office Specialist Authorised Testing Centre (MOS and MCAS)

Prodigy Platinum Learning Partner

Institute of IT Training - Accredited Training Provider
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
Association of Computer Trainers verified by visa, mastercard securecard