drop down to dispolay no of bars to display in chart

Hi,

I need a drop down above the chart displaying values 1-12, selecting which the same number of bars shall be displayed in the chart which user can scroll.

Any help shall be highly appreciated.

PFA the worksheet for reference

Thanks in advance.

Hi
You already have a scroll bar displaying between 3 and 12 bars for each country, so I'm not sure what you want the drop down to do. Can you explain further?

Yes DBY. Alongwith the scroll bar there should be a drop down at the chart displaying the numbers 1-12. selecting these numbers, the same number of bars should be displayed at a time. for e.g. if selected 1, one bar should be selected , displaying one bar at a time to scroll 11 more times till december. when selected two, two bars should be displayed, and scroll bar should move 6 times to display till dec. when selected 3, three bars should be displayed and scroll bar should move 3 times to display till dec. Hope this clarifies.

Hi
I think I get it but I'm having trouble with the scroll going past the available months. I'll get back if I find a solution.

Test out the Chart on the Monthly_spend tab, is this what you're looking to achieve?

Somewhat like this only, DBY. But the problem that I am facing and in the chart you also suggested, what needs to be improved is, the months should not repeat at scroll. and not repeat at end too when months end in between. for e.g. when selected 5, on screen 1, it should display only jan, feb, mar, apr, may. scroll 1: jun, jul, aug, sept, oct. scroll 2: nov, dec. thats it.

Thank you so much for your efforts DBY. I really appreciate it. I have been actually been pushed into a new profile and all this stuff is new to me.

So sorry. I had two files with the same name (bad idea!), uploaded the wrong one. Attachment above should be correct.