Macro for Chart Scaling

[herve]

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

[Jon Peltier]

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" <[email protected]> wrote in
message news:[email protected]...
>
> 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
>