Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a chart that has Times on the Y Axis created with an time(floor(ADate, 1/24),'hh TT') as Chart_Time expression
for example
6 AM
7 AM
8 AM
I am trying to add a vertical reference line on 7 AM
I've tried
=7
='7'
='7 AM'
=time('07 AM','hh TT')
and haven't hit on it, any thoughts?
I think either of these would work:
=timestamp#('9/9/2011 9:01:00 AM','D/M/YYYY h:mm:ss TT')
=makedate(2011,9,9)+maketime(9,1)
Hmm, tried both (I appreciate all the help greatly BTW) but still no joy
Wonder what's breaking it.
Did you put it on the Y-axis instead of X-axis? To put a reference line on the X-axis, you need to select "continuous" for the dimension. Use the number tab to fix the formatting. An X-axis reference line defined with either of the expressions above then works just fine for me.
Great! That was it!