Have you tries setting the x-axis labels vertically? Maybe it does not think you have enough space for closer labels.
Javier, Javier Valencia, PE 913-915-3137 From: rbase-l@googlegroups.com <rbase-l@googlegroups.com> On Behalf Of johnd...@gmail.com Sent: Monday, July 24, 2023 4:29 AM To: RBASE-L <rbase-l@googlegroups.com> Subject: Re: Re[2]: [RBASE-L] - R:CHARTS - Adjusting the Label Increments on a DateTime X Axis Hi Bruce, I have tried various things as suggested. and more, including just having one series, but the only control that I can get to adjust the label spacing is the minimum separation. Not sure what is awry here as I have managed to get this to work previously. Thanks for your help. Regards John Docherty On Monday, July 24, 2023 at 6:14:42 PM UTC+12 johnd...@gmail.com <mailto:johnd...@gmail.com> wrote: Hi Bruce, Thanks very much for taking the time to reply. I am just back home so I will look at this tonight. To answer your questions though:- 1. The data is from three tables with different time stamps. I can force the start time to be the same as this is just one day's data. The sampling interval differs. Not ideal but one set of data (pressure) was sampled at a higher rate than the temperatures. 2. The two hours came from a drop down list. I will let you know how I get on. Thanks again. Regards John Docherty On Monday, July 24, 2023 at 8:29:25 AM UTC+12 Bruce Chitiea wrote: 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 <tel:(909)%20238-9012> m | rby...@safesectors.com <mailto:rby...@safesectors.com> ------ Original Message ------ >From "johnd...@gmail.com <mailto:johnd...@gmail.com> " <johnd...@gmail.com ><mailto:johnd...@gmail.com> > To "RBASE-L" <rba...@googlegroups.com <mailto:rba...@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 <mailto:rby...@safesectors.com> ------ Original Message ------ >From "johnd...@gmail.com <mailto:johnd...@gmail.com> " <johnd...@gmail.com ><mailto:johnd...@gmail.com> > To "RBASE-L" <rba...@googlegroups.com <mailto: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 <mailto: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+u...@googlegroups.com <mailto:rbase-l+u...@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 <mailto:rbase-l+unsubscr...@googlegroups.com> . To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/546f92f6-a970-4ed8-930b-a5e80cea001fn%40googlegroups.com <https://groups.google.com/d/msgid/rbase-l/546f92f6-a970-4ed8-930b-a5e80cea001fn%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/09bb01d9be6d%2408004b50%241800e1f0%24%40vtgonline.com.
