100% Stacked Bar Chart based on Active Form?

Post Reply
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

100% Stacked Bar Chart based on Active Form?

Post by macsir »

Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any idea?
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: 100% Stacked Bar Chart based on Active Form?

Post by macsir »

Alright, it ends with fixed number of data series, say top 10 or top 15. It can't be dynamic, otherwise it has to be in VBA.
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
User avatar
paulsimon
MVP
Posts: 808
Joined: Sat Sep 03, 2011 11:10 pm
OLAP Product: TM1
Version: PA 2.0.5
Excel Version: 2016
Contact:

Re: 100% Stacked Bar Chart based on Active Form?

Post by paulsimon »

Hi macsir

Not sure if you have already answered your own question. We had similar issues with a Waterfall chart. However, as the user only wanted to see the Top 6, we recorded MDX for this and then pasted it in to Excel and concatenated in the appropriate variables, and used this in the Active Form.

Regards

Paul SImon
User avatar
macsir
MVP
Posts: 782
Joined: Wed May 30, 2012 6:50 am
OLAP Product: TM1
Version: PAL 2.0.9
Excel Version: Office 365
Contact:

Re: 100% Stacked Bar Chart based on Active Form?

Post by macsir »

macsir wrote: Fri Oct 12, 2018 11:04 pm Hi, has anyone implemented this chart before? The problem I have is the multiple data series for the chart has to be manually fixed in advance. It can't be dynamically based on the rows or columns from the active form. Named range doesn't work. VBA doesn't work in TM1 web. Could anyone share any idea?
Thanks, Paul. Yes, the top N can be done using MDX. However my problem is that in some excel charts, the data series have to be fixed and stacked bar chart is one of them. See what I linked with red lines in legends entries section from the snapshot. You can try it also in excel if still not clear. :P
stacked.PNG
stacked.PNG (50.71 KiB) Viewed 2206 times
In TM1,the answer is always yes though sometimes with a but....
http://tm1sir.blogspot.com.au/
Post Reply