Hi,
I am doing a project with excel and have been watching a lot of videos and reading on the web to be able to do what I am planning to do but have not found a good solution yet.
Basically I am creating an interactive dashboard where I am allowing people to choose from the first section one option with a radio button, depending on that section they have a drop-down menu created with data validation, and then depending on that selection, one more data validation drop-down. In total I have around 20 possible combinations.
My aim is to show a different graph (completely different from different data and tables, so dynamic graphs are not an option) depending on the selections.
I tried doing it without a macro by inserting an object/image and using formulas such as indirect, etc. and it worked but the quality of the image that gets imported is terrible and it also takes absolute ages to refresh.
My request and question is how I can make it work with a macro and make it run permanently so I don't have to hit "run" each time I make a selection?
Eg. If cell C3 = 1 and cell D4 = "Revenue" and cell F4 = "Year", show graph1... If C3 = 2 and ........ show graph2, etc
Someone told me I could cheat by putting all graphs on top of each other where I want to show them, and create a macro to bring to front the chart that I want to show. However, I still don't know how to make it work, especially having the first option as a radio button.
If there is another way of doing it I would be very grateful if you could enlighten me!
Also, where would I have to have my graphs? Same sheet or a different one?
Thanks ever so much for your help!!
I am doing a project with excel and have been watching a lot of videos and reading on the web to be able to do what I am planning to do but have not found a good solution yet.
Basically I am creating an interactive dashboard where I am allowing people to choose from the first section one option with a radio button, depending on that section they have a drop-down menu created with data validation, and then depending on that selection, one more data validation drop-down. In total I have around 20 possible combinations.
My aim is to show a different graph (completely different from different data and tables, so dynamic graphs are not an option) depending on the selections.
I tried doing it without a macro by inserting an object/image and using formulas such as indirect, etc. and it worked but the quality of the image that gets imported is terrible and it also takes absolute ages to refresh.
My request and question is how I can make it work with a macro and make it run permanently so I don't have to hit "run" each time I make a selection?
Eg. If cell C3 = 1 and cell D4 = "Revenue" and cell F4 = "Year", show graph1... If C3 = 2 and ........ show graph2, etc
Someone told me I could cheat by putting all graphs on top of each other where I want to show them, and create a macro to bring to front the chart that I want to show. However, I still don't know how to make it work, especially having the first option as a radio button.
If there is another way of doing it I would be very grateful if you could enlighten me!
Also, where would I have to have my graphs? Same sheet or a different one?
Thanks ever so much for your help!!