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
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)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks