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


"(E-Mail Removed)" 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
<ShaneDevensh...@discussions.microsoft.com> 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
>
> "hcac...@gmail.com" 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), (E-Mail Removed) 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
><ShaneDevensh...@discussions.microsoft.com> 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
>>
>> "hcac...@gmail.com" 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), hcac...@gmail.com 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
> ><ShaneDevensh...@discussions.microsoft.com> 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
>
> >> "hcac...@gmail.com" 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 -