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.