100% Stacked Bar Chart based on Active Form?
- macsir
- MVP
- Posts: 785
- 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?
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?
- macsir
- MVP
- Posts: 785
- 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?
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.
- 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?
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
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
- macsir
- MVP
- Posts: 785
- 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?
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.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?