4 Replies Latest reply: Oct 14, 2013 5:42 AM by Friedrich Hofmann RSS

    Additional info - not stacked - in a barchart

    Friedrich Hofmann



      for my latest diagram, I have chosen the "pure" barchart instead of the multi-diagram which I normally use.

      That way I could stack columns on top of each other.

      The structure of the data is as follows:

      - In one or more out of five areas, a report might or might not have been generated - so each has a 1 or a 0

      => By stacking all of them, I get the total number of reports as well as the info where they come from.


      Now I'd like to display another piece of info in that diagram:

      -> How many of those reports have been processed? (often 0, always equal/ less than the nr. of reports generated)

      Obviously, I would not like that number to be stacked on top of the others

      => Rather, it should appear in front (thus covering) the nr. of reports generated (it doesn't matter which segment gets covered)


           maybe I could make the columns appear shaded in case one/more reports have been processed.


      Currently, I have that as a separate formula, but without any column for it - just the number on the axis.


      Can anyone here give me a hint how I could achie

        • Re: Additional info - not stacked - in a barchart
          Michele Barini


          do you want something like this?


          You select bar and value on data points on the display options of the expression tab.

          Then you could work with the dual function

            • Re: Additional info - not stacked - in a barchart
              Friedrich Hofmann

              Hi BBI_MBA_76,


              I don't know what you are displaying in this diagram - but to me that looks like just several expressions stacked on top of each other with the whole thing being horizontal?

              Currently I have the chart like this




              You see there are 5 expressions stacked - only 4 are 0 in value, so you see only the one.

              There on the x-axis I have my "invisible" expression - just the number is visible - representing the nr. of processed reports. The text "Erledigt:" is a free_text_box.

              What I would like (to replace those numbers on the axis) is another expression (column), but NOT stacked on top of the others - which seems to happen automatically in that diagram_type? - but rather in_front_of/ covering the other columns with a dark_green or black column or so.


              Can I do that at all in this one diagram or would I have to create another diagram on top of this one with just the one expression?

              => That way I'm sure I could do it

              <=> It would be quite time-consuming probably to make sure the new diagram does show exactly the same dimensions etc. as the old one.


              P.S: I have tried this out, now - I can make the second diagram transparent, but not so the dimension_labels; These still show, and strangely enough, they are in different places than they are in the first diagram, so they appear like double.


              P.P.S.: This does not seem a good idea after all - I tried editing the base file for just one day so I would have something to display in the "foreground-diagram" - and guess what, the column appeared to the right of the original column...