Stacked bars in Active Form
Posted: Tue Dec 03, 2024 10:02 am
Hi All,
I'm facing the following problem:
I want a stacked bar chart using Excel. So no special functionality of PAW available.
I have a number of periods, used for rows, and a number of materials used for columns. Both are defined by a dynamic Subset via MDX.
So I need to put the materials in the columns, because this dimension should be stacked, but the number of columns is dynamic. I used the trick to define a table (Ctrl-T) for the grafic, but this does not solve the varying number of columns of the view.
Any idea or hint?
BR
Dirk
I'm facing the following problem:
I want a stacked bar chart using Excel. So no special functionality of PAW available.
I have a number of periods, used for rows, and a number of materials used for columns. Both are defined by a dynamic Subset via MDX.
So I need to put the materials in the columns, because this dimension should be stacked, but the number of columns is dynamic. I used the trick to define a table (Ctrl-T) for the grafic, but this does not solve the varying number of columns of the view.
Any idea or hint?
BR
Dirk