thanks a lot problem solved. Went through the related link on your site and
got the required code.

pdfr

"Jon Peltier" wrote:

Turn on the macro recorder while you adjust the scale manually to get an
inefficient version of the VBA code.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"pdfrone" wrote in message
...

thanks do you know how to set the scale in vba or vb.net

"David Biddulph" wrote:

If the axis is formatted as time, it shouldn't be a problem. If it
doesn't
choose the scales to give clean divisions, you can choose an appropriate
unit on the axis, such as 03:00.
--
David Biddulph