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 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 m | *rby...@safesectors.com* >> >> ------ Original Message ------ >> From "johnd...@gmail.com" <johnd...@gmail.com> >> To "RBASE-L" <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 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+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. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/546f92f6-a970-4ed8-930b-a5e80cea001fn%40googlegroups.com.