I am creating a report with a list that contains some descriptive information and a microchart for each row. The microchart display usage numbers over time. However, the scale of the numbers that contribute to the chart vary widely from row to row.
What seems to be happening is the Microchart is settling on one scale to use for all the rows, leaving me with charts that cannot be read at all for some rows, due to their numbers being so small relative to the scale.
Is there a way to set the microchart to use different scale in each row, one that is approriate to the row's local data? I know that I can have the report normalize the data, but I'd rather display the raw numbers if possible.
thanks
rob
Hello all,
If anyone is interested, I was able to find a solution, which perhaps should have been readily apparent.
If you select just the y-axis of the chart in Report Studio, to get axis-specific properties, there is in fact a property labeled 'Use Same Range For All Instances', and setting it to 'No' does exactly what one would expect.
rob