Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > PowerPoint

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-20-2015, 05:04 AM
andytheanimal andytheanimal is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 10
andytheanimal is on a distinguished road
Default Embedded Excel in Powerpoint - custom animation, display column by column

I have an Excel object embedded in my Powerpoint which consists of seven columns with multiple rows. What I would like to do is get Powerpoint on each click, to display the spreadsheet column by column.



I'd like the change to explain what each column is to the audience before they see the next as the whole lot is quite a lot to take in, in one 'show all' approach.

Not sure if this is possible as I cannot locate anything on it. Any workarounds? I can create 7 iterations to be displayed one after the other (with increasing columns not hidden)? If this is the best workaround, how do I get one Excel file to disappear and the subsequent one to appear? How that makes sense.
Reply With Quote
  #2  
Old 01-20-2015, 05:44 AM
JohnWilson JohnWilson is online now Windows 7 64bit Office 2010 32bit
Programmer
 
Join Date: Nov 2008
Location: UK
Posts: 1,743
JohnWilson will become famous soon enoughJohnWilson will become famous soon enough
Default

You cannot animate an Excel object by column.

Two possible (not perfect) workarounds

1. Cover each column with a PowerPoint shape and give the shapes a disappear animation
2. Cut the object and paste special as an EMF

Ungroup twice and you should be able to animate the individual parts. Of course it is no longer an Excel object which may be totally unacceptable.
__________________
Microsoft PowerPoint MVP
Free Advanced PowerPoint Tips and Tutorials
Reply With Quote
  #3  
Old 01-20-2015, 06:30 AM
andytheanimal andytheanimal is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Oct 2014
Posts: 10
andytheanimal is on a distinguished road
Default

[quote=JohnWilson;76760]
1. Cover each column with a PowerPoint shape and give the shapes a disappear animation
quote]

I like the sound of this approach, thanks for the thought.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
How can I temporarily break a 3 column format in order to type a single column paragraph William P Word 1 01-04-2015 06:40 PM
Want a quotient using a constant to show up in column c each time a number is added to column b fibbermcghee Excel 2 12-09-2014 05:48 PM
Excel Fomula to search for a string and display value from different column zeeshanbutt Excel 1 07-29-2012 12:48 AM
Can I change the horizontal scrollbar to scroll smoothly rather than column by column carpat Excel 0 01-10-2012 09:34 AM
How do I do Custom Column Spacing Fucius Word 1 08-31-2011 02:01 AM


All times are GMT -7. The time now is 09:44 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft