Defining range based on series of values and creating a bar chart based on that

[#1]

Hi Guys,

I have come across a problem. I have different accounts and each account have multiple contacts.

I want to create a chart which shows the x% of accounts (in Y axis) have contacts in range 1-5, 6-10, etc.(on X axis).

I am attching a excel file with dummy data.

Please help me out.

[#2]

Hi Rishikesh,

Check the attached QVW for the solution.

Thanks,

Shruthi

[nilesh_gangurde]

PFA

Hope this will help you

-Nilesh

[#4]

hi

please check this

hope it helps u

[#5]

Guys..thank you very much for your replies. I really appreciate all of yours solutions, but Shruthi's solution served my purpose the best, Thanks Shruthi and thanks all of you 

[#6]

Hi Rishikesh,

Please mark the question as answered.