How to change the graph data by click button

If i click "Jan tab" then then graph should update the value related to jan month and then if clicked "Feb tab" then related value should update in the graph,
Please help .

Hi there,

In the attached file, I have added a 'List Box' from where you can select a month.
The selected month will show in cell W1.
This value is then used to populate the amount from your table in column 'W'.

Exsample cell W3:

Formula:

Please Login or Register  to view this content.

The charts are then linked to this dynamic sets and will update to the selected month when changing it via the 'List Box'.

Note: I have only done the formulas in column 'W' for Jan to Jun. You will need to extend for the rest of the year, you see the pattern... Also only did the first 3 Regions, Turkey still to be done.

Let us know how you go with that.

Thanks a lot , It's working