ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   animated / motion / chart Excel (https://www.excelbanter.com/charts-charting-excel/193469-animated-motion-chart-excel.html)

[email protected]

animated / motion / chart Excel
 
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

animated / motion / chart Excel
 
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


[email protected]

animated / motion / chart Excel
 
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



Tushar Mehta (Microsoft MVP Excel 2000-2008)

animated / motion / chart Excel
 
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


[email protected]

animated / motion / chart Excel
 
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 -




All times are GMT +1. The time now is 01:07 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com