Dashboard -> how can I show the data behind a chart (= creating a pop up) ?

[MarkD]

Hi,


im just a beginner in excel dashboards, but maybe you can help me.


The basic question is how to create 2 layers (top and bottom) like some sort of pop up, so more data can be shown if wanted:


I ´d like to show the data (or a picture or whatever) behind a 5 column chart by clicking a checkbox (the data is not very big and static).


I have seen Chandoos Tutorial http://chandoo.org/wp/2011/07/20/interactive-dashboard-using-hyperlinks/ for Hyperlinks


How can I do this?


Thank you very much

 

[Faseeh]

Hi MarkD,


Welcome to the Forums!! You can increase the transparency level of the chart to higher values say 85% and place the picture in the background so that it is visible. Do you want to show it as default background of the chart or you want to show it only when some one chooses to see it?


Regards

 

[MarkD]

Hi Faseeh,


it should not be set as a background. It should show up by click only.


Edit: It does not necessarily be a "pop-up". Im totally glad, if the chart disappears and the data field appears.

 

[Faseeh]

Have you tried using camera tool?

 

[MarkD]

Yes I did. But how can I create a clickable button now in the dashboard to make it show-up?


(and by the way - where in the profile options can i change this scary avatar? ;-) )

 

[SirJB7]

Hi, MarkD!

About the avatar question, check this:

http://chandoo.org/forums/topic/offftopic-avataricon

Regards!

 

[Brij Arora]

MarkD
Can be done using name range based on offset formula and picture tool. I have created the same and uploaded the sheet for your reference . Here we are doing the two things

• Picture = name range
• Name Range = offset formula (value updated through checkbox)

hope you find this reply useful.

inspired from @chandoo 's world cup dashboard

Brij A