Stack columns in a multi-diagram?

[datanibbler]

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

[datanibbler]

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