I would like to force the x axis of a bar chart to stay at the same position, regardless of the values being displayed, so that when I show the data as a time series, I get an effect like a graphic equailizer.
Is that possible? I attach a file showing example of what happens just now, that is, the x-axis moves up and down, depending on the size of the largest negative and positive values.
I have achieved close to what I want by adding a dummy dataset containing the maximum and minimum value I want to show, then removing the border, shadow and gradient fills from the display and setting the colour for the max and min value to white. All I need to do now is work out if I can remove the numbers from the tops of the columns, do that I dont leave "hanging values". By calling my maximum and minimum data !Max and ZMin I force them to be the first and last values.
You can hide the labels at the top of the bars by selecting "Tools > Layout > Show measure labels at top of bars" in the Bar view toolbar. However, in certain cases it wasn't working which I have fixed in tonight's release. The fixes should be available from 2.6 build 503 or later.
I think that's what WKeith wants. There's no way using this trick to get the bars to be cropped by a smaller range. All it does is ensure at least the range given is shown.
I hadn't considered cropping high/low value ranges - to do that you would need to set up a column with an if clause that replaced the "real" value with the "Max" or "Min value if it exceeded it or went below it - also 0 needs to be in the range to be dsiplayed, though I guess you could subtract a constant from each value........
To achieve the same result in 2.6 5.04 (where I managed to hide the numbers at the top of the columns) I had to use a white "background" .jpg file, to prevent Visokio "helpfully" forcing outlines round the white bars - it does that for white on white. The .jpg fools it.