Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Interactive Dashboard

0

Hi variatus,

I have checked the instructions you have send me on the previous post and I have created the chart events as per attached file.

Chart 1,2 and 3 are form sheet "source data". Chart 4 is from sheet "cost" and Chart 5 and 6 are from sheet "tools".

I have added one more sheets name as Raw data from which i made my charts. But these data comes from the other 3 sheets namely: Source data, cost and tools.

Can you please help me to brings all these chart in one sheet named as "Dashboard 1" and when it click on those chart it brings me to its respective sheet and at a specific cells.

I also need to mentioned that my graphs will be dynamic. Data for more days will be inlcuded and sometimes data for previous days will be deleted from graphs.

excel
MS Office Version: 2013
posted by: naqiym (rep: 8) on Mon Mar 30, 2020 at 9:15 am
Answer
Discuss

Discussion

Hi Variatus,

Please advise if you can further help me on this.

Thanks
naqiym (rep: 8) Apr 2, '20 at 4:04 pm
Hello Naqiym, I didn't mean to abandon you. Just waiting for someone with better knowledge of the subject to step forward. Of course, the generic subject of your question, "interactive dashboard" doesn't help. I believe your current question is "How to combine several charts on one Chart sheet?" Coming to think of it you may agree with me that it is well hidden and not advertised in the caption. My answer is that I can find out. But if I can search the web so can you. That leaves me stuck on the question why I should invest an hour of my time on research of a question nobody asked. Perhaps you can do that part and teach me how you did it. I would then look into the code. BTW, when you modify my files in the future please change the date in their names so that their versions can be told apart.
Variatus (rep: 4889) Apr 2, '20 at 8:38 pm
I am also trying Variatus.
naqiym (rep: 8) Apr 3, '20 at 11:32 am
Add to Discussion



Answer the Question

You must create an account to use the forum. Create an Account or Login