I'm using Peltier's
http://peltiertech.com/Excel/Charts/...ertSeries.html
to draw a vertical dotted line on a time series chart (to "split" the
chart at the current date). But I can't get the vertical line in the
right place. I think it's setup correctly:

Today
5/21/2006 0
5/21/2006 1

I think the problem is the secondary axis scale. Excel thinks it's a
number series instead of a date series. Any help on how to tell Excel
it's also a date series, or any other ideas on how to get the line in
the right place? Thanks.