Detach some charts

[richard_chilvers]

I have some charts on a sheet which show KPIs and I don't want them to be affected by any selections made on the sheet. I was hoping to detach them each time the sheet is activated/opened.

Is this possible? Or is there a different way to achieve the same thing ?

Thanks

[avinashelite · Accepted solution]

Hi ,

You have two options,

1.Right click on the chart and detach.

2.Impose alternate state on the chart which don't need to change according to the selection

[MK_QSL]

Use Alternate State !

[richard_chilvers]

Thanks.

Hadn't played with this feature before, but its ideal.

[jagan]

Hi,

In your expression just give 1 like below

=Sum({1} Sales)

OR

=Sum({1<SomeDimension={Some Values}>} Sales)

Hope this helps you.

Regards,

Jagan.

[jagan]

Hi,

Detach is not a good option everytime when you reload Detach option will be gone.  Instead you can bypass the selections by giving 1 in set analysis

=Sum({1} Sales)

OR

=Sum({1<SomeDimension={Some Values}>} Sales)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

How do you do this ? impose alternate state that don't change according to selection

[Anonymous]

Can you please explain the second one in detail? how do you impose a alternate for not selecting?