Dynamic graph based on listbox

[Galactico076]

Hello, I'd like to get some help with making a dynamic graph with use of listboxes. Please see attached example.
In the example doc is a graph which is now static. Based on the rows I selected in the table, for store 1 and for february.
What I'd like is that a user can select a store and a month in 2 listboxes and that the graph is dynamically created based on dynamic selection in the table. I think I need to use the OFFSET function and some defined names but I'm not sure how.

Kind regards.

[Bhuvi]

Hi Galactico,

In the attached sheet, drop downs are in cell K2 and M2 based on values in list in col H and I.
Though it is not a list box but it provides the same solution desired by you.

Note : col G and N are helper columns, you can hide them.

I hope this meets your requiremnts.



<if this helped , please click on the Star * below this post to add some reputation>

[Galactico076]

Thank you Bhuvi! This is exactly what I needed.

[Bhuvi]

You are welcome and thanks for adding reputation

Now since its apparent that you are satisfied with the solution you've received and have solved your question.

You can mark thread as solved.
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.