You're welcome. I meant to add, because of the ease of use of dates rather
than computing months, I almost always use Day(s) as my Base Unit.

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


"Alan" wrote in message
...

"Jon Peltier" wrote in message
...
Well, duh, I never clicked on the link.

Double click on the X axis. What is the Base Unit? If it is Day(s), you
can simply plot your XY series using the desired date. If it is Month(s),
you need to convert the date to elapsed months. October 2006 comes out to
the 1281st month (2006-1900)*12+(10-1). To put a vertical line between
October and November 2006, use X=1281.5 for your XY series.


Jon,

I know you are probably immune to the thanks and praise, but I am
seriously impressed!

Thank you, thank you, thank you!!

Alan.

--

The views expressed are my own, and not those of my employer or anyone
else associated with me.

My current valid email address is:



This is valid as is. It is not munged, or altered at all.

It will be valid for AT LEAST one month from the date of this post.

If you are trying to contact me after that time,
it MAY still be valid, but may also have been
deactivated due to spam. If so, and you want
to contact me by email, try searching for a
more recent post by me to find my current
email address.

The following is a (probably!) totally unique
and meaningless string of characters that you
can use to find posts by me in a search engine:

ewygchvboocno43vb674b6nq46tvb