

Partner - Master II
2011-05-23
08:52 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
toggle values in a pie-chart
hello I have a pie chart
in the expressions tab I have put the sum(field)
is there a way to toggle the checkbox (Relative) from a button on the sheet?
I can walk on water when it freezes
4,651 Views
2 Replies

Contributor III
2011-05-23
09:36 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There is not such a button but you could't create one by making use of a macro. The easiest way is to create 2 pie charts. One with absolute and a second with relative values.
361 Views


Partner - Master
2011-05-23
09:49 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
I use it in a different way with the same result.
Create a second and identical expression
sum(field) and check the relative box.
Then, you group those expressions (with the Group Button below the expressions box).
This will include a cycle expressions button, and the user can click it to change visualization
Hope it helps,
Erich
