Scatter Chart Time (Y) vs Date (X)

[blori]

Team, I've search and can't find my answer again. I had this charted 1x but lost my hard drive, so need help to refigure this out please.
I simply want to plot time vs date ....so I can show IT when their files are coming in. I am sure it is not that difficult, but when I change the major units to 0.0146666666 as I saw in one example it total messes up the dates.

if someone can assist, I would greatly appreciate the guidance ~ hope the attachment shows, I need to show them their files are coming in much later. please help Thanks Lori
Attachment 187864

[dilipandey]

Hi blori,

That was because your date and time are in text format.. now I have corrected them.. see the attached file :-
ScatterChart_TimeVsDate.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[blori]

this is awesome, except how do I make the dates match what in actually being plotted. My date range = 8/8 -10/16, the chart is showing January
how do I make the chart match the actual data?

[dilipandey]

Oopss.. I missed to apply the formula and copied down the values only for date column

Now corrected.. see the attached file.. thanks.
ScatterChart_TimeVsDate(1).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[blori]

now the times are wrong

now wonder I had such issues, this is not an easy process ~~ I am glad you know how to do this and appreciate your help

[dilipandey]

time is correct.. see the attached graph which I have expanded for your view...

ScatterChart_TimeVsDate(1).xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[blori]

Dil, ok that was my bad, I didn't recognize the 'clock' just circled ~~ dahhhh on me
how can I change the Time so there is more showing ~ I tried playing w/ the Major / Minor but it is not working
sorry to keep bothering you
I will save this so can reuse and learn

[dilipandey]

Time varies from from 0 to 1 only and all day is covered in between. for example 12 AM is 0 and 6 PM is 0.75

As a test put following and you'll see difference
Min:-0.15
max: 0.5

Regards,
DILIPandey

<click on below 'star' if this helps>

[blori]

still not working
maybe I am trying to see more time values shown as in 9:30, 10:00, 10:30 ect so it is showing the time every 30 min ~ so the manager has a very clear pic
what am I doing wrong?

[dilipandey]

I would suggest you to expand the height of the chart and set everything to auto..
Also as an option try showing less data.. may be 12:AM to 6 AM and then you'll understand and can play around with time scale.. and after that you can refresh you full data once comfirtable.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>