John:

It's been a while since I've standardized my axis' configs, rusty now on charting anomalies.

First the data.

(1) Date/Time is captured in 1/100th second intervals, with values presumably recorded in each of the three tables; sourced from a family of sensors performing a whole lot of sampling. Do discrete data points in each of the three tables align upon a common date/time value, e.g. all three tables have a data point containing dateTime value 08/06/2023 03:09:03.03? (meaning they share a common Label value. If not, there's a View trick to overcome the anarchy for charting purposes.)

(2) Do all three series share the same horizontal spatial configurations of the series chosen for labels?

(3) How does R:Charts recognize the Scale Increment text value "Two Hours"?

(4) My experience of axis configuration is similar to yours. The frequency and spacing of Labels seems to depend on the frequency and spacing of Tick Marks. I can't say I know everything about that. But note the variance of minor/major Tick Mark spacing along the axis. The spacing of the minor ticks in the first and sixth segments is reduced relative to those within the second through fifth segment, suggesting a "crowding" . Take a shot at standardizing the spacing:
-- Chart Editor > Chart > Axis > Bottom Axis >
-- Ticks Tab: Reduce the "Minor" Count to = 1 (or 0, as the Minor Ticks aren't very useful here)
-- Labels Tab > Styles Sub-Tab: Play with the "Min. Separation %" value

(5) Thinking, too, that the width of each dateTime value may be a factor. Granted, your Labels Tab > Style Sub-Tab > [x] Multi-line staggers the Labels; but note the uniformity of the vertical margin spacing between the top and bottom row. You may be "minned out" for horizontal adjustment. Perhaps redefining your Label value solely as a Time data type might provide lateral flexibility?

Hope there's something there for you.

Best, Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 m | rby...@safesectors.com

------ Original Message ------
From "johnd...@gmail.com" <johndoc...@gmail.com>
To "RBASE-L" <rbase-l@googlegroups.com>
Date 7/23/2023 11:58:26 AM
Subject Re: [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis

Bruce,

Thanks for your reply. I have attached two pdfs, one showing the settings I am using and the other the resultant graph. Changing the settings seems no have no effect on the labels so presumably I am doing something wrong. The data is being plotted from three tables with differing datetime values.

Any suggestions that you have would be much appreciated.

Thank you.
Regards
John Docherty

On Monday, July 24, 2023 at 2:12:53 AM UTC+12 Bruce Chitiea wrote:
John:

Please send a screenshot or PDF of the challenge.

Bruce

Bruce A. Chitiea | SafeSectors, Inc.
112 Harvard Ave #272 | Claremont CA 91711-4716 | USA
+011 (909) 238-9012 <tel:(909)%20238-9012> m | rby...@safesectors.com

------ Original Message ------
From "johnd...@gmail.com" <johnd...@gmail.com>
To "RBASE-L" <rba...@googlegroups.com>
Date 7/23/2023 3:53:37 AM
Subject [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis

Hi,

I am having difficulty setting the increments between labels / gridlines on a X Axis which consists of datetime values. While I have managed to get this to work properly in the past I have had no success with the current data. If anyone can tell me how to set the increment to say 2 hours that would be greatly appreciated. (Even if I try to use the 'standard' intervals from the drop-down list that does not change the labels or their spacing. Presumably I am doing something wrong, but I am not sure what that is....)

Thanks.
Regards
John Docherty

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+u...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/7d9b5ed1-860b-4a19-8e6b-b80be7308c5an%40googlegroups.com <https://groups.google.com/d/msgid/rbase-l/7d9b5ed1-860b-4a19-8e6b-b80be7308c5an%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group. To unsubscribe from this group and stop receiving emails from it, send an email to rbase-l+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/891d53e0-b957-41aa-874a-903162e6d383n%40googlegroups.com <https://groups.google.com/d/msgid/rbase-l/891d53e0-b957-41aa-874a-903162e6d383n%40googlegroups.com?utm_medium=email&utm_source=footer>.

--
For group guidelines, visit 
http://www.rbase.com/support/usersgroup_guidelines.php
--- You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rbase-l/emd10ccd54-b410-4b92-af47-5cc7d28fd34f%40b6fc8f9c.com.

Reply via email to