Hello
I am trying to make the scale of a Plot vs. Depth column on a report log user defined. The logarithmic option for Scale Type in the Main Properties tab presents the data logarithmically, but there is no option to display scale lines. As a result, I have been superimposing a Lines at Values to serve as the scale lines. This approach is adequate as long as the scale max and min are static. I would like to make these user defined, though, so the scale can be adjusted depending on data range. Thanks for your help!
Ryan
Hi Ryan,
What you are doing is correct.
I have had to do this many times for Log reports, if I wasn't able to come up with a min/max combination that would handle enough of the data I would create one or two other min/max combinations and then rely on the "overflow" option to indicate off-scale values.
With a logarithmic scale you generally use full log cycles so that you have 2 or 3 log cycles max, otherwise it is difficult to distinguish the values, especially if you are including many lines in your scales.
You could create a number of Lines at Values entities, one for each min/max scale range that you need. You could offset them on the Log report page and then use an Output Condition to select which one to display and specify a Offset X value that would then "offset" the particular Lines at Values entity to the correct location on the Log report.
Alternatively, you could place each of these Lines at Values entities into separate Internal Log Blocks and then call the respective block with an expression based upon the scale range that you want for that set of data.
Dave...
Great. That's what I ended up doing. I have one static Line at Values, but the scale numbers may plot as 0.1,1,10 or 1,10,100 or 10,100,1000 depending on the range of the data. Thanks for the help.
Hello,
anybody has an idea if this has been improved in gINT or do we still have to manually create these lines?
Thank you
Jerome
The log report plot vs depth entity does have an option to create vertical scale lines. This may not work for a log plot (never tried it) but it certainly works for an arithmetic plot. The fence plot vs depth entity does not have this option. I presume you are talking about a fence report not a log report.
Like you, I have used lines at a static x - position many times on fence reports but have always been able to know exactly where those lines needed to be. I have often wondered if the fixed curves expression option on the fence report version could be used to generate these lines on a fence report but never had to try. You might want to try it. For example you could specify fixed curves at 0.1, 0.2, 0.5, 1, 2, 5, 10, 20, 50, 100, 200, 500, 1000. Then set your scale using an expression and if they plot out of the scale range they wouldn't show. You would still have to deal with the scale labels though. This would allow you to have ranges of varying number of cycles 0.1 to 1 and 0.1` to 1000 would theoretically be possible. I may try this soon and will report back if I do. If you try it first let me know.
I just checked and indeed the logarithmic graph on a log report does not generate scale markers and values in the same way that an arithmetic report does (told you I had never tried it). I may look into using fixed curves to do this in the next few days but need to brush up on fixed curves first.