Animate Cell By Cell Excel Calculations

[Guest]

I have an excel file that calculates a set of variables to one conclusion.
There are 15 rows by 4 columns.
I want to
(a) have the spreadsheet appear, at first showing only the data in column
A1 to A15 (data titles), and the column headers (A1, B1, C1, D1)
(b) advanced by mouseclick, have each cell total come up sequentially B2,
B3, B4 ... B15 (each by mouseclick)
(c) advanced by mouseclick, have all of column C (C2 ... C15) and then
column D (D2 ... D15) to come up
I'm guessing this is a tall order, but I've got three hours to figure it out.
Marla Galasso
BSM Consulting, Incline Village, NV

 

[Guest]

AFAIK the only way to do this is to have a series of near duplicate slides.
This is obviously a bit fiddly and makes a fairly big file but done correctly
it can look good

Maybe someone knows better.
--

 

[Guest]

Not exactly eloquent, but you could create several small rectangles with no
line and a white fill so they hide the values in the table, group each row or
column of rectangles,then set their exit animations to "Disappear" on a mouse
click.

 

[Guest]

Maria,
After pasting the excel onto PowerPoint, you can ungroup it twice (Right
click on the excel, select Grouping > Ungroup. Repeat the steps again). You
can then animate the textbox individually.
--
Shawn Toh (tohlz)
Microsoft Most Valuable Professional (MVP PowerPoint)

Site Updated: April 13, 2006
Added new portfolio
http://pptheaven.mvps.org
PowerPoint Heaven - The Power to Animate

 

[Glen Millar]

Hi,

I answered this one in an offline email. My response was:

The quick way I can think of is copy it in Excel, paste special as wmf,
ungroup, then regroup to animate. On my web site is a tutorial on graphing
called complex animations:

http://www.pptworkbench.com/html/Complex_Animations.htm

--

Regards,

Glen Millar
Microsoft PPT MVP

Tutorials and PowerPoint animations at
www.pptworkbench.com

glen at pptworkbench dot com

Please tell us your PowerPoint / Windows version,
whether you are using vba, or
anything else relevant