Thanks for your reply,Jon. I tried using the data table format that you
have given and I was able to create a much better chart than what i
have been able to do so before. On the x axis though, i get numbers and
not dates as desired. I would like to get dates on the x axis.

I went through the article that you have mentioned in your post

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

The article states the following -

Quick Trick: Even though Excel expects a number (for example, April 1,
2004 = 38078) in the axis scale parameter boxes of a value axis, you
can type in a date, and Excel will convert it for you. This works if
you are entering times, as well.

When i tried changing the - Value (Y) axis scale - i changed the
minimum to 9/9/2005 , maximum to 30/9/2005, it gave me an error - Your
entry cannot be used. An integer or decimal number may be required.

Thanks and Regards,


--
excelprogrammer
------------------------------------------------------------------------
excelprogrammer's Profile: http://www.excelforum.com/member.php...o&userid=26923
View this thread: http://www.excelforum.com/showthread...hreadid=467460