Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
When i select any value from my list box ,the stack bar chart data should remain as it is, how to do that.
You can detach your chart (in general tab of chart properties), or use set analyis (like sum({1} Value) ) in all your aggregations.
ok how to avoid the word detached in the title
and also while reloading the script the detach is not working
Its better if you use the second choice given by swuehl .
Simply do like this:
=Sum({$<YourFieldInListBox= >} Value)