animated / motion / chart Excel

[hcacote]

Hi,

Is there any way to animate animate charts in Excel 2007.

I have yearly series (2008, 2009, 2010, 2011)

For example I would like that the chart being displayed would change
with the year.

Is there the possibility to do this inside of Excel? Using a macro (if
there's a possibility without a a macro the better).

Thank you, Cheers,
Hugo

 

[ShaneDevenshire]

Hi,

There are a number of ways to do this but we need more info, show us a
sample of the data layout.

 

[hcacote]

Hi Shane,

I have the data that I am displaying is in the following layout:

Product Type Stage 2008 2009 2010
X HPT 5 3 2
Row 1 1 4 4
Row 3 2 3 6
Row 4 3 6 4
Y HPT 4 8 4
Row 1 5 9 5
Row 2 6 8 6
Row 3 7 8 8
Row 4 8 4 8
Z Row 2 9 3 4


Thank you,

Hugo

 

[Tushar Mehta (Microsoft MVP Excel 2000-2008)]

So, given the data what do you want to animate?

Hi Shane,

I have the data that I am displaying is in the following layout:

Product Type Stage 2008 2009 2010
X HPT 5 3 2
Row 1 1 4 4
Row 3 2 3 6
Row 4 3 6 4
Y HPT 4 8 4
Row 1 5 9 5
Row 2 6 8 6
Row 3 7 8 8
Row 4 8 4 8
Z Row 2 9 3 4


Thank you,

Hugo

 

[hcacote]

Hi,

I would like to able to either:

1/ Show just one year, two years or the 3 years

or

2/ Show the data year by year sequentially


Thank you, Cheers
Hugo