How do I make bar chart for TOP 10,20,30,40

[ksiddiqui]

I want to add in my bar graph that give option to the person to see result byt top 10,20,30,40 however he like please suggest how can I do. i know in filter we can limit once but I want to know how to do multiple in one graph?

[theoat]

You can use the variable imput slider.
I will write you a demonstration.

[theoat]

First, set a variable. Default value 10.

Next, add the variable input object to your sheet.

 

Set it up on slider, with the variable created, with a minimum of 10, a maximum of 40 and a step of 10.

 

Then, add this variable to the dimension boundary.

The graph then adjusts to the value chosen on the slider.

Kind regards,
Théo ATRAGIE.

[ksiddiqui]

Thanks for the above idea but what if I don't make the slider and give the option in x axis the way drilling is done.

[theoat]

Alternatively, you can create one button per top to analyze. Each button will assign the variable a value (example: 10). The slider option is more convenient.

[theoat]

If you don't set the option to the absisse axis, the chart will not be responsive to slider selection.

[ksiddiqui]

What if I want to make it into a drop-down then how can I do it and can we customize the size of the title because in variable input I cannot see any option for styling?