• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Hiding chart

C

cswshaun

New Member
Hi all

I have a text box and a pivot chart overlapping.

I would like to configure the text box to be shown by default when cell value or slicer selection is (All)) while the chart should be hidden by default.

And when cell value or slicer selection is not (All), chart is shown while the text box becomes hidden.

How can I do this please, thank you!
 
To change the visible properties or the z-order requires a macro.

Alternatively you could place each over a separate range and switch a picture from one to the other using a named formula e.g.
selection: =IF( chart?, chart, textbox )
and the picture has
=selection
in the formula bar.
 
You must log in or register to reply here.
Back
Top