So I've been trying to create this websheet based on an active form with a chart at the bottom. However, the rows are compressed so that they can dynamically expand when the user wants to see only the parents.
The problem I am facing is that when the parent is expanded, the chart no longer uses the rest of the range... just the first row in the set.
I tried using a dynamic named range but to no avail. Has anyone put a chart in a active-form based websheet... if so, how?
Dynamic Named Ranges and Active Websheets
-
kangkc
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: Dynamic Named Ranges and Active Websheets
Look at TM1 manual, it's specifically mentioned that you CAN'T insert objects like Chart.
"
When you insert an Active Form in a worksheet, the form ’owns’ all rows that are required to display the form. You cannot insert additional data or objects (such as charts or images) in any row that is occupied by an Active Form, as the data/object will be deleted when the form is recalculated. "
I did this in a really dumb way:
I plot my chart on top of the active form dynamic row section using source data from another NON-active form slice. With this I can have chart as well as tabular reports on same page, however the chart will not be related directly to the active form selection but for my case it works as it's for different objectives.
"
When you insert an Active Form in a worksheet, the form ’owns’ all rows that are required to display the form. You cannot insert additional data or objects (such as charts or images) in any row that is occupied by an Active Form, as the data/object will be deleted when the form is recalculated. "
I did this in a really dumb way:
I plot my chart on top of the active form dynamic row section using source data from another NON-active form slice. With this I can have chart as well as tabular reports on same page, however the chart will not be related directly to the active form selection but for my case it works as it's for different objectives.