how to keep graph detached from other objects

[#1]

I have a sheet with several graphs where each graph shows a catagory of the data and a table box which covers all categories of data.  I want the graphs to always stay full of all the data for their category and when I make selections in my table I want just the table to colapse and show only the selection while the graphs remains as a pictoral reference of the whole data environment.  When I right click on the graph and select "detach" from the pull down I get the desired result but only while that graph is displayed. as soon as I minimize the graph it looses its "detach" setting.  How (or can) I make the "detach" setting stick until I choose to release it?

[alexandros17]

Use Alternate states ...

Hope it helps

[Nicole-Smith]

If you want to ignore selections on certain objects, you can use {1} in set analysis.

Examples:

sum({1}Sales)

sum({1<Product={'Fruit'}>}Sales)

[#4]

Go to Document properties -> General tab -> Alternate states (its between the button "Help Pop-ups" and "Memory statistics".

Choose add, and give it a name, for example "State1".

Now go to the properties of your chart -> general tab. In the middle at the top of this tab, you have the header "Alternate state". It's standard on "<inherited>". Change this to state you just created (in my example "State1").

The graph should now not be affected anymore to the selections you make in your tables, but alway display all data.

[#5]

thank you very much for the detailed how-to