Results 1 to 2 of 2

Vertical line alignment with X-axis

Threaded View

  1. #1
    Registered User
    Join Date
    06-16-2011
    Location
    Utah, USA
    MS-Off Ver
    Office 2007/2010
    Posts
    7

    Vertical line alignment with X-axis

    Hello, all. As I am new here, I'd appreciate knowing if I overlooked some search that would have answered my question. I looked about and found nothing directly applicable, but sometimes that's just a matter of learning the right search terms.

    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 on the "Graph" sheet of the workbook -- 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?
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1