+ Reply to Thread
Results 1 to 2 of 2

Vertical line alignment with X-axis

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

    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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,434

    Re: Vertical line alignment with X-axis

    The horizontal axis is a category one the labels just happen to look like values.
    So with the xy-scatter series on the primary axis the x values need to be 17 rather than 1307738985
    Attached Files Attached Files
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

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