Macro for Chart Scaling
 

Hello All,
could someone know a macro that could scale a chart (in X).

Exemple,

from A1 to A365, I have dates 1/1/2005 to 1/1/2006.
The chart I have start from 1/1/2005 to 1/1/2006.

I would like - by clicking on a CommandButton - to change the 1st date
and the 2nd date (that I have put in cell B1 and B2)

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile: http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=521039

Macro for Chart Scaling
 

Herve -

This is explained on this page:

http://peltiertech.com/Excel/Charts/...nkToSheet.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services - Tutorials and Custom Solutions -
http://PeltierTech.com/
2006 Excel User Conference, 19-21 April, Atlantic City, NJ
http://peltiertech.com/Excel/ExcelUserConf06.html
_______

"herve" wrote in
message ...

Hello All,
could someone know a macro that could scale a chart (in X).

Exemple,

from A1 to A365, I have dates 1/1/2005 to 1/1/2006.
The chart I have start from 1/1/2005 to 1/1/2006.

I would like - by clicking on a CommandButton - to change the 1st date
and the 2nd date (that I have put in cell B1 and B2)

Regards

Herve


--
herve
------------------------------------------------------------------------
herve's Profile:
http://www.excelforum.com/member.php...o&userid=27314
View this thread: http://www.excelforum.com/showthread...hreadid=521039