combo chart

[#1]

Hello,
I need help for create an object "combo chart".
I have a table (look attached document). I should analyze my indicators by month and type. My values ​​in the list type are not fixed. Now I only have two values ​​(A and B), tomorrow I can have 3, 4 or more values. I want to have a presentation with bar on stacked (with different types) and two average values ​​on line. You have an example in attached document for the expected result. The difficulty for me as my values ​​in the list” Type” are not fixed. I must use the type as a dimension in my chart. I cannot simply set the value in an expression (for example sum ($ {<type={'A'}> Myindicator). but if I create my object in two dimensions. I cannot have bar on stacked.

Thanks for your helps

[Anonymous]

Load it as a cross table (using the table loader wizard to rotate so your Type's end up in one dimension, and the values in another. Then you can simply stack over the dimension holding the types.