This may help you in your quest to be able to do the dates. not sure about the scale.

http://www.peltiertech.com/Excel/Cha...micLast12.html

This will create a slider with offsets to be able to change a date range on one axis.

HTH.