Predefined segments in stacked bar chart

[magertgen]

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

[magertgen · Accepted solution]

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