Hi Bruce, Thanks for your reply. This used to work on another database, not the current set of data.
The options I see are as attached. Not sure why there are different from what you have. (I am using the latest version - just checked that.) I am having to leave this in the meantime, but thanks very much for your help. If I manage to resolve this I will let you know. Regards John Docherty On Tuesday, July 25, 2023 at 2:06:51 AM UTC+12 Bruce Chitiea wrote: > John: > > Intrigued by (a) it worked before, and (b) your drop-down Increment > observation. > > Here's what I get for: *Bottom Axis > Scales > Increment > Change:* > > > Hmmm. > > Bruce > > > ------ Original Message ------ > From "[email protected]" <[email protected]> > To "RBASE-L" <[email protected]> > Date 7/24/2023 2:29:06 AM > 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 [email protected] 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 | *[email protected]* >>> >>> ------ Original Message ------ >>> From "[email protected]" <[email protected]> >>> To "RBASE-L" <[email protected]> >>> 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 | *[email protected]* >>>> >>>> ------ Original Message ------ >>>> From "[email protected]" <[email protected]> >>>> To "RBASE-L" <[email protected]> >>>> 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 [email protected]. >>>> 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 [email protected]. >>> >>> 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 [email protected]. > > 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/rbase-l/f1bc2e7b-e1e0-4016-8d1a-ce121a63da3an%40googlegroups.com.
Increment Options.pdf
Description: Adobe PDF document
