Hi

I need to plot a graph with temperature on Y axis and the date and time values on the X axis. However, the date needs to be shown only when it changes. Time needs to be shown at regular intervals, e,g. on the grid line. I need to use the scatter smooth line with nomarkers option of MS-Excel. I am using MS Excel 2003.

I also need to be able to zoom selected region in the graph and unzoom it.

Can anyone show me how to code with VBA for the above.
Thanks in advance.
Bala