Hi Gnana,
u can try using pivot chart

"Gnana Prasad" wrote:

I have a problem like i have around 5 branches and each branch i have 5
sectors. we do sales for the sectors and also record the collections.

Now the requirement is i need to have a chart which depicts the above infor