Visokio website     Downloads     Video tutorials     KnowledgeBase  
Keeping axis on bar graph at same height - Visokio Forums
Keeping axis on bar graph at same height
  • VoteVote Up5Vote Down     WKeith January 25, 2011 10:07AM
    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.

    Many thanks

    Keith Guthrie
    Attachments
    visokiorequest.doc 205K
  • 17 Comments
  •     edward January 25, 2011 11:01AM
    The X axis moves up and down to accommodate bars which may vary over a wide range. It is currently not possible to disable this behaviour.
  •     WKeith January 26, 2011 7:13AM
    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.image
    Attachments
    equaliser.PNG 10K
  •     steve January 26, 2011 7:50AM
    Nice workaround. Re-classify as an Idea and vote for this - we'll consider for 2.7.
  •     mustafa January 26, 2011 8:19AM
    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.
  •     WKeith January 26, 2011 9:34AM
    Thanks for that - I was looking to do it in 2.5, which is what our users see - When will 2.6 be beta/mainstream?
  •     steve January 26, 2011 9:37AM
    We don't have an exact date. We hope for beta within the next few weeks, but support and fixing is taking far longer than anticipated.
  •        benjamin January 27, 2011 7:25AM
    How does this work ?? ...Adding a dataset with Max and Min Values will this only work if those values are outside those of the orirginal dataset..
  •     steve January 27, 2011 8:54AM
    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.
  •     WKeith January 28, 2011 4:11AM
    I was trying to do it in 2.5, as that is what my users have. Keen to see 2.6 beta/production as mentioned elsewhere.
  •     WKeith January 28, 2011 6:24AM
    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........
  •     WKeith January 31, 2011 11:25AM
    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.
    image
    Attachments
    Capture6.PNG 19K
  •     steve January 31, 2011 12:42PM
    To sum up, we need an option to set min/max fixed values for the bar view. I've given Keith another vote on this for his dedication.
  •     WKeith January 16, 2012 11:30AM
    Could this be put back into the 2.7 alpha? - "Tools > Layout > Show measure labels at top of bars"

    Cheers
  •     steve January 16, 2012 11:34AM
    It's here, and now per-measure:

    Measures > [each measure] > Scale > Show value labels
  •     WKeith January 16, 2012 11:42AM
    thanks

Welcome!

It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership