animating excel chartgraph
Microsoft Office TrainingThe UK's Number 1 for Microsoft Office Training Sitemap add this page to your favourites/bookmarksBookmark page
 
view a printable version of this pagePrintable version
Plus One Google
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

resolvedResolved · Urgent Priority · Version 2003

replyReplyThu 8 Oct 2009, 16:04Delegate Ludovic said...

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!

For upcoming training course dates see: Pricing & availability

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

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.

 

 

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

Powerpoint tip:

Doodling on your active slides

To add a little graphic interest during a presentation, switch on the Pen with Ctrl+P. Now your mouse can be used to draw on the slide. Ctrl+E switches on the Eraser to rub things out, and Ctrl+A brings back the Arrow.

At the end of the presentation you have the option to save or discard any un-erased doodlings.

View all Powerpoint hints and tips

article

No More Shaky First Steps Thanks To Microsoft Project's Ribbon

Taking your first steps into Microsoft Project may seem like the most difficult and to help you get started the software has an easy-to-navigate ribbon. The tabs described later see you setting up the application quickly so those first steps aren't quite so shaky.

» Article: Ms project training

forum postCan you use SUMIF function with multiple criteria, eg:

Sum column D, if A=Yes, B=Yes and C=No.

» Forum post: SUMIF


Rate this page:
2.2/5 (213 votes cast)
Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses
Microsoft Certified Partner
Security Seal verified by visa, mastercard securecard

Mini sitemap. These are the main areas of our web site. Full sitemap.

Management training

Professional Skills courses
Project Management Course London
Project Management Courses London
Project Management Training London
Project Management Training
Project Seminar
Project Seminars
Time Management Course London
Time Management London
Time Management Courses London
Time Management Training London
Introduction to Finance course
Assertiveness Skills course
Effective Communications Skills training
Presentation Skills London

Training Formats

Public scheduled courses
On-site training
Closed company courses

Consultancy
Application Development

Blogs

Excel Training
MS Project Training
Microsoft Training Blog

Version differences

Office 2010 vs 2007
MS Project version differences

Training Information

London Computer Training
Computer Training London
Docklands Training Courses
Docklands Training London

Training venues London
Client list
FAQ
Pricing and availability
Course details / Syllabus

Training Articles
Training Information

Microsoft training

Microsoft Office training
& IT Applications

Microsoft Project training
Microsoft Outlook training
Microsoft Powerpoint training
Microsoft Word training
MS Project courses
MS Project training
Outlook courses
PowerPoint courses
PowerPoint training
VBA courses
Word courses
Microsoft.training
(more...)

Excel Training

Excel courses
Excel Training Courses Medway
Autonumber in Excel
Microsoft Excel training
Basic Excel Courses
Basic Excel Course
Basic Excel Training

Interested in MS Access training?

Access courses
Microsoft Access training
Microsoft access courses
Microsoft training access course
Microsoft+access+training
Access courses in london

Training provider

Training providers
IT training companies
IT training providers
Management Training providers
Management Training provider

Event history, feedback results
Events in 2012 · 2011 · 2010 · More

See also

Crystal Reports training