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.