toggle values in a pie-chart

[ali_hijazi]

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?

[yasus]

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.

[erichshiino]

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