Chart Y-Axis

[simgschw]

Hi,

I have a bar chart and a crosstab in my report.


The property Auto from range of y axis is set to true, but the y-axis displays any values. The max value should be 274 or above and the chart displays as max value 6. Why is the range calculated in that way? I do not want to set the maximum at runtime, I think this is a job for the designer.

I also want to display a trendline. But the chart does not show the trendline. How can I display a trendline?


You can find the sample report and its data in the attachements.

Thank you!
Greetings

[Lech Kulikowski]

Hello,

Please send us a sample report with test data which reproduces the issue for analysis.

Thank you.

[simgschw]

Data.csv

(5.65 KiB) Downloaded 173 times

DmsDokumentDatenAnalyse_Forum.mrt

(26.52 KiB) Downloaded 166 times

Data.csv

(5.65 KiB) Downloaded 173 times

The report uses CSV data as datasource

Data.csv

(5.65 KiB) Downloaded 173 times

[Lech Kulikowski]

Hello,

Sorry, maybe we did not exactly understand your question. Could you explain your issue in more details, which result do you need?

Thank you.

[simgschw]

Hello,

Question 1
I want to display a trendline. In the chart editor there are properties for trendline only for style, but how can I enable the trendline?


Question 2
I do not want to set the maximum and minimum value of y-axis, the chart should do this automatically. But when the chart does this automatically the scalling is somehow confusing. I my sample the biggest value in the chart is 274, the range of y-axis is [0-6]. For my example the maximum value of y-axis should be more than 274.

Do you understand?

[Lech Kulikowski]

Hello,

You use Auto Series and DateTime, in that case, avg values are used. Please do not use DateTime Step property.

TrendLine on the screenshot in the attachment.

Thank you.