1 Reply Latest reply: Jul 11, 2013 6:46 AM by Friedrich Hofmann RSS

    Stack columns in a multi-diagram?

    Friedrich Hofmann

      Hi,

       

      in a meeting yesterday I got the feature-request that a diagram should have stacked columns:

      It is currently a multi-diagram, showing data from two separate lists (columns) and the total (line). I have found the feature on the "design" tab, but it seems I cannot use that feature with a multi-diagram.

      Is there any way around that?

       

      Thanks a lot!

      Best regards,

       

      DataNibbler

        • Re: Stack columns in a multi-diagram?
          Friedrich Hofmann

          Hi,

           

          it seems this is simply not possible. I can stack columns only in a pure barchart, but then i cannot show lines.

          An alternative might be to define the "column offset" (formula properties) so that this is equal to the value I would show in the other formula.

          That looks a bit weird, but it works fine - for the individual values.

          The diagram, however, can also show the cumulative YTD-values - the difference is just a checkbox on the "expression" tab. How could I achieve the same effect in an expression (in the formula properties)?`

           

          Thanks a lot!

          Best regards,

           

          DataNibbler