+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    11-08-2008
    Location
    mi
    Posts
    1

    chart y axis is stacking...with data?

    Hello everyone. I'm new to the forum, and looking for some help from the pros!

    I am charting a date//time relationship for tickets. I have a column with a date, such as 10/27/08, and i have a column with a time such as 4:08:52 PM. when i make a graph of the columns, seemingly ever other date is stacked on my graph. so on my y axis i have 12am-12pm, and then another 12am-12pm right above it, and i have no idea why its stacking the data. The cells themself are identical, aside from the change in date.
    I'm not sure exactly how to describe it, so I made a screen shot of it. I just want to collapse the data points so they all lie in the same 12am-12pm range.
    If anyone can shed some light on this issue, Id' greatly appreciate it.

    Thanks in advance!
    ~jeep
    Attached Images Attached Images

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944
    I assume the second column of data that displays time actually contains a date as well, which is why the why values are in bands of 12-12.

    Assuming your data is in columns A and B put this formula in column C and use this new value for the Y values.

    =B1-INT(B1)
    Cheers
    Andy
    www.andypope.info

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.2.0