1 Reply Latest reply: Oct 20, 2015 2:33 PM by Mark Gertgen RSS

    Predefined segments in stacked bar chart

    Mark Gertgen

      Hey all, I'm looking to create a combo chart with stacked bars.  I want the bar segments to be defined ranges, and have the line show the value.

       

      So for each time period (dimension) I'd have a bar with 0-99, 100-199, 200-299, etc, with each bar showing ALL the segments.  I'm sure this can be done, but I've searched and for the life of me can't an example of how to do it.  (Of course, maybe it can't be done and that's why I can't find any examples.)

       

      I've never had to do this before and it has me scratching my head.  Any help would be appreciated!

       

      Thanks in advance,

       

      ~Mark

        • Re: Predefined segments in stacked bar chart
          Mark Gertgen

          OK, I figured this out.  I simply created an expression for each segment, starting with the bottom segment.  Each expression is simply a number for the range of that bar segment.

           

          For example, if you wanted five ranges:

          0-200

          200-400

          400-500

          500-600

          600-1000

           

          Your expressions would be

          200

          200

          100

          100

          400

           

          This worked great and the line segment plotted correctly in the bar segments.

           

          ~Mark