Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel Chart Scaling | Charts and Charting in Excel | |||
Scaling within a chart | Charts and Charting in Excel | |||
Setting Chart Min, Max and other scaling | Excel Programming | |||
value of chart scaling | Excel Programming | |||
Chart Scaling | Excel Programming |