DPlot

rborn · Joined: 18 May 2004 Posts: 18 Location: New Jersey

Ok, your going to hate me now.

When it brings in the time for the X axis, it evidently converts it to an integer. I know this since the extents it uses are 0.2 and 0.8 for the time (X axis). How it actually displays the time correctly is beyond me but impressive. Surprised

So evidently you divide the actual time by 24 to get the integer value, Excel works the same way. Here is where I'm wondering if there is a workaround. My problem is that I'd like to round the extents off to round hours, specifically 5:00:00 am and 6:00:00 pm. If you do the math, this gives you 0.2083 and 0.75 for integer values. It seems the extents get rounded to the 10th's position so the values it rounds to are 0.2 and 0.8 respectively, which comes out to 4:48 am and 7:12 pm, not exactly what I was looking for.

Any suggestions?

DPlotAdmin · Posted: Wed May 19, 2004 4:59 pm Post subject:

rborn · Joined: 18 May 2004 Posts: 18 Location: New Jersey

I'm not sure if you miss-understood me or I am just confused. I agree you would not want to mess with Add-in for rounding and I don't want to round my numbers.

I'll try to explain it another way. I go to Options, Extent/Tick Marks/Size. My X axis with the time is a bit uneven, so to speak, with the Automatic scaling (extents). It starts at 4:48:00 AM and ends at 7:12:00 PM. I'd like it to be more rounded and have the X-Axis start at 5:00:00 AM and end at 6:00:00 PM. There is no data before 5:00 AM or after 6:00 PM and this just narrows down the time and makes everything nice and clean, to me anyway. I think you can undersand that it would be easier to read an axis from 0 to 10 than from -0.134 to 12.567, for an extreme example. The Automatic function does a nice job, but I'm sure you put in the extents and such to customize it for this exact reason.

So the problem I have is, the Low and High extents only hold a x.x number, if I add a number such as 0.2834, it will become 0.2. With the time on the X-axis this will never allow me to get exactly 5:00:00 AM. I said in my last message what the decimal number is for that but I don't have it now...I guess it would be 5/24 or 0.2083, which always rounds to 0.2, which is 4:48:00 AM, kind of an unround number, for time anyway.

If your suggestion in the last post was to fix this, I guess I didn't understand it.

PS: I did try to add that function but it gave me "Syntax error in function", I simply added "round(X*24)/24" to the X= box.

DPlotAdmin · Posted: Wed May 19, 2004 6:00 pm Post subject:

Ah... well I completely misunderstood. That dialog needs a bit of work for times. Right now you have to enter the extents as days, and whatever you enter will very likely be rounded off to something else, dependent on whether you also specified a tick mark interval. I'll change this to input date + hour... or something.
_________________
Visualize Your Data
support@dplot.com

DPlotAdmin · Posted: Wed May 19, 2004 6:47 pm Post subject:

BTW you can do what you want now, though it's a bit inconvenient. In addition to specifying the extents you need to also set the tick mark interval on the X axis to 0.0416666666666666666667. The extents will then be integer multiples of 1 hour.
_________________
Visualize Your Data
support@dplot.com