Prev: Changing only Legend Text
Next: changing from days to months
From: hcacote on 2 Jul 2008 10:43
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
From: ShaneDevenshire on 2 Jul 2008 15:08
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


"hcacote(a)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
>
From: hcacote on 2 Jul 2008 15:24
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...(a)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...(a)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

From: Tushar Mehta (Microsoft MVP Excel 2000-2008) on 3 Jul 2008 12:57
So, given the data what do you want to animate?

On Wed, 2 Jul 2008 12:24:16 -0700 (PDT), hcacote(a)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...(a)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...(a)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
From: hcacote on 4 Jul 2008 03:33
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(a)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...(a)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...(a)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...(a)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 -

 | 
Pages: 1
Prev: Changing only Legend Text
Next: changing from days to months