Hello all,
I have a query regarding Charts in a report. Our report has a line graph . The graph type is "Line with Markers".
We have graph between 2 columns say A and B.
Now for the axis of A we want the minimum and maximum values to be between another two columns say C and D.
Let me illustrate with an example.
Suppose A has value of 12, 15, 16, 18, 20, 21.
C has a value 10
D has a value 25.
By default when we plot the graph it plots from 0 to 21. We want that it should plot graph from 10 to 21 i.e. for axis the minimum and maximum values should come from columns C and D respectively.
Can this be done and if yes then how? An early response will be appreciated.
Regards,
Anup