Dynamic Chart Title
- 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:
Dynamic Chart Title
Looks like it is not supported in TM1 web although I can refresh it in Excel. Just want to confirm it?
-
- MVP
- Posts: 3230
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.1.5
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: Dynamic Chart Title
Hello,
I did a simple test and can confirm that it does not work, Excel 2013 and TM1 10.2.2.4.
I did a simple test and can confirm that it does not work, Excel 2013 and TM1 10.2.2.4.
Best regards,
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- garry cook
- Community Contributor
- Posts: 209
- Joined: Thu May 22, 2008 7:45 am
- OLAP Product: TM1
- Version: Various
- Excel Version: Various
Re: Dynamic Chart Title
Annoyingly not in 10.2.2.2 - 10.2.2.4 - had dynamic lookups for Product Group names mapped from string cube hierarchy points and had to go with the low tech option of putting the title in an Excel cell fitted to the graph floating above the graph.
Doesn't look great but did the job - dynamic name changing of the Graph header but not held inside the actual border of the chart.
Doesn't look great but did the job - dynamic name changing of the Graph header but not held inside the actual border of the chart.
-
- MVP
- Posts: 3702
- Joined: Fri Mar 13, 2009 11:14 am
- OLAP Product: TableManager1
- Version: PA 2.0.x
- Excel Version: Office 365
- Location: Switzerland
Re: Dynamic Chart Title
This is the workaround I have always used - put whatever text is required for the chart in a formula driven cell and place the cell directly above the chart or behind the chart and make the chart background transparent. It has always worked for me; with some additional effort but I wouldn't say any detrimental visual impact.garry cook wrote:Annoyingly not in 10.2.2.2 - 10.2.2.4 - had dynamic lookups for Product Group names mapped from string cube hierarchy points and had to go with the low tech option of putting the title in an Excel cell fitted to the graph floating above the graph.
Doesn't look great but did the job - dynamic name changing of the Graph header but not held inside the actual border of the chart.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
- 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: Dynamic Chart Title
Thanks, guys. I also did that.