Animate an Excel chart?

[acap]

Does anyone know how to animate an Excel chart? It's a very basic chart showing the stock price increase in value. I want to insert the chart in a PowerPoint presentation and show the stock price slowly increasing in value. Here are the values I have in each cell. Thank you!

<table border="0" cellpadding="0" cellspacing="0" width="64"><colgroup><col style="width:48pt" width="64"> </colgroup><tbody><tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt; width:48pt" align="right" height="17" width="64">A1:$10</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A2:$12</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A3:$15</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A4:$17</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A5:$20</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A6:$25</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A7:$30</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A8:$35</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A9:$40</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A10:$50</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A11:$60</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A12:$70</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A13:$90</td> </tr> <tr style="height:12.75pt" height="17"> <td class="xl24" style="height:12.75pt" align="right" height="17">A14:$110</td> </tr> </tbody></table>

 

[Trevor G]

You would have to use something like a Flash move or a third party software like fusion charts.

Here is a link to take a look

http://www.fusioncharts.com/

 

[Weaver]

Personally, with that relatively small amount of data, I'd build a bar chart using shapes in Powerpoint, then increase their size over a number of slides.

 

[acap]

Thanks for you help everyone. I guess I'll just create several slides and show the increasing graph that way. It's a bit messy, but I thought there might be a simpler way. I downloaded the trial version of Fusion Charts, but have no idea how to use it; I wouldn't mind learning it, it's just that I probably won't use it again to retain the info.

 

[pgc01]

Hi
Welcome to the board

You can animate a chart in excel, and if you paste link it in powerpoint you could see the animation there.

In order to do that you'd have to know vba and be comfortable with the chart object model or shapes manipulation.

The easiest way is to animate the chart source data, the rest will follow.