Dynamic Dashboard

Greetings EE Pros!

I am trying to create a dynamic dashboard with data on Sheet2, reflecting in the dashboard on Sheet1.  I was thinking that "Camera" would be the way to go, but cannot figure out how to use it properly.  I also need a small macro that will hide and display the image/dashboard on  Sheet1.  I have created a mock version for you to take a look at.

Thank you in advance.

B.
Dynamic-Dashboard.xlsx
Bright01Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Is this what you want?

Check it out, if it does what you want let me know & Ill add instruction and the macro later. I'm off to work at the moment but I'll check back later
Dynamic-Dashboard.xlsx
0
Bright01Author Commented:
Roy,

Almost!  The screenshot/picture updates correctly, however two things;

1. This is a dashboard that will appear on Sheet 1 (and it does).  However, I need it to have a macro that displays it and hides it which is in the original ask.

2. I definitely need directions on how to accomplish this.  There appear to be no macros so I'm assuming you used the Camera Function.  I can't find any help on how to use it.

Thank you very much and I think the next pass will  be perfect!

B.
0
Roy CoxGroup Finance ManagerCommented:
I'll follow up later.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Roy CoxGroup Finance ManagerCommented:
It's quite simple and does not need the Camera Tool

1. Select the table of data.
2. Use the NameBox in the top right to name the selected area. I used "Data"
3. In the Dashboard sheet add any image and resize to the dimensions that you want
4. With the picture selected, in the formula bar type = Data and press enter.


I've added code to show/hide the picture
Dynamic-Dashboard.xlsm
0
Bright01Author Commented:
Roy,

So close!  I'm having trouble with the directions.  

I select the table of data.
I did not see a "NameBox at the top right; so I gave it a RangeName (AnalyzerDashboard)
On the Dashboard Sheet, you say "add any image"..... what image?  A shape?  How do I add an image? Do you mean picture?
How do I add a picture?

There is where I'm stuck.

B.
0
Roy CoxGroup Finance ManagerCommented:
Sorry, I thought you would be familiar with the Name Box. It's top right of the worksheet, typically displays the selection address. If you hover the cursor over the box it will pop up saying Name BoxSimply select your data range then type into that box a suitable name and click enter. You will see the name in the Name Manager.

When I said add any image just go to the Insert Tab and select picture. then insert any file image on your computer. We are only getting a holder for your table to display. When inserted and sized select the picture and type into the formula bar - = the name of your range. Click enter.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Bright01Author Commented:
Roy,

So my NameBox is on the left side of my  Ribbon.  I got it in terms of selecting the cell range and typing in the name  in the Name Box.  I'm good with that part.

When I go to the Insert Tab, I can add a picture....but it looks for a picture that I have on my laptop or On-Line.  Do you mean select a shape? and then linking the rangename to the shape?  Or how do I create a picture container?

B.
0
Bright01Author Commented:
Roy,

Figured it out!!!!  Thanks for all the help.  Great job coaching me through the procedure.  Way cool!

B.
0
Roy CoxGroup Finance ManagerCommented:
Pleased to help. It's a little trick I've used for years when I need to prevent access to the actual data
0
Bright01Author Commented:
Neat.... I'm enjoying using it already.

B.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.