How to create a bar chart to show the number of clients by revenue?

[#1]

Hi,

I want to create Bar chart to show number of clients by Revenue?

Client	Revenue
C1	1000
C2	2000
C3	3000
C4	2000
C5	5000
C6	8000
C7	12000
C8	3000
C9	1000
C10	2500

I want the X axis (dimension) to be bucketed say 0-1K , 1-2K, 2-5K, 5-10K, >10K

How can I group the data to display the count of clients that falls with the dimension? The dimension could be dynamic (probably driven by slider)? For simplicity sake lets keep the dimension static as I mentioned

Or is there any other easier way to show number of client by revenue ?

Appreciate your help

Thank you

[Alejandro_Hernández · Accepted solution]

here's an example with 2 ways of doing it.

[#3]

In the same lines how can we make the dimension dynamic. Like user controls using a slider or so based on the Revenue amount. Basically I want the user to define the buckets on the fly. Any Ideas please ?