topic Re: How do I make bar chart for TOP 10,20,30,40 in Featured Members

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

ksiddiqui — Thu, 15 Feb 2024 10:36:05 GMT

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?

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

theoat — Thu, 15 Feb 2024 10:39:28 GMT

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

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

theoat — Thu, 15 Feb 2024 10:51:06 GMT

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.

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

ksiddiqui — Thu, 15 Feb 2024 10:56:02 GMT

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.

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

theoat — Thu, 15 Feb 2024 10:59:22 GMT

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.

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

theoat — Thu, 15 Feb 2024 11:06:47 GMT

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

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

ksiddiqui — Sun, 18 Feb 2024 05:59:31 GMT

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?