2 Replies Latest reply: Dec 13, 2012 10:31 AM by Howard (... in Training) RSS

    I how to restrict in bar chart y axis repeated values

    pnr
      Hi,
      Why Y-axis values reapeating like 0 0 1 1 2 2 3 3 when search results gives single bar.
      I need show always single values like 0 1 2 3 4.

      How to reduce bar size if get only one value single bar occupies whole chart.



      thanks
      Nr
        • 1. Re: I how to restrict in bar chart y axis repeated values
          Dimitri Gielis
          Hello,

          You could do a distinct in your query, that gives only one value of its kind.
          Would that help?

          Regards,
          Dimitri
          ----------------------------------
          http://dgielis.blogspot.com/
          http://www.apex-evangelists.com/
          • 2. Re: I how to restrict in bar chart y axis repeated values
            Howard (... in Training)
            I know this is a really old question but ...

            I thought I'd provide a little insight since I had the same problem. If, as in the case described, the values are specified to have 0 decimal places, and the range of the data is, say, between 0 and a small number then the Y scale/range may be 0.0, 0.5, 1.0, 1.5, 2.0, ... But at 1 decimal place, these may display (truncated?/rounded) as 0, 0, 1, 1, 2, ... The easy solution would be to specify 1 (or more) decimal places. However, the easy solution has other effects. My stacked bar chart was very dense with only enough room to show a single digit for the Values. This became unreadable when the value 1 (one) was replaced by 1.2 and 2 by 2.3. So I unchecked display Values. (Why couldn't the values display staggered like labels do so they they don't overlap?)

            So even though, I had intended to display "values," I had to give that up when I showed additional decimals in the labels.

            Howard