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

Hi,

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

--
Thanks,
Shane Devenshire


" wrote:

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

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

On Jul 2, 9:08*pm, ShaneDevenshire
wrote:
Hi,

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

--
Thanks,
Shane Devenshire

" wrote:
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

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

On Wed, 2 Jul 2008 12:24:16 -0700 (PDT), wrote:

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

On Jul 2, 9:08*pm, ShaneDevenshire
wrote:
Hi,

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

--
Thanks,
Shane Devenshire

" wrote:
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

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

On Jul 3, 6:57*pm, "Tushar Mehta (Microsoft MVP Excel 2000-2008)"
<ng_poster@tushar-underscore-mehta-dot-cee-oh-em wrote:
So, given the data what do you want to animate?



On Wed, 2 Jul 2008 12:24:16 -0700 (PDT), wrote:
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

On Jul 2, 9:08*pm, ShaneDevenshire
wrote:
Hi,

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

--
Thanks,
Shane Devenshire

" wrote:
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- Hide quoted text -

- Show quoted text -