Vertical line alignment with X-axis

[treesloth]

So, I have a spreadsheet (2007) that has a graph. The primary x-axis consists of ordered UNIX timestamps. The primary y-axis is various metrics collected from a server. I'm trying to create a vertical line at certain timepoints so that it's easy to see the effect of certain actions on the server. I've gone through the Peltier example for a series-based vertical line, but I keep running into 2 strange problems:

1) The vertical line's placement seems completely unrelated to the timestamp that is part of the data series. See image -- I've placed dots on the data series where the line should appear. The vertical line is based on the little "Val" section to the left of the graph. It seems to insist on being way off to the right. The trick, it would seem, would be to get Excel to either use exactly the same values for the secondary horizontal axis as for the primary, or simply to use the primary horizontal axis for both vertical axes; but how? Or is there something I'm overlooking?

2) Whenever I try not to display the secondary axes, Excel crashes. What in the world could cause that?

Please let me know if I've been unclear. I thought it was possible to post the workbook here, but I see that it isn't, and reviewing the alternative from the FAQ suggests that it won't really help with this problem. Many thanks in advance.

 

[treesloth]

Please pardon me if this isn't allowed, but this post was knocked off the first page almost immediately upon posting. Perhaps I took too long to write it? Anyway, any thoughts would be appreciated.