Drawing pareto chart

Hi All,

I have a requirement to draw a pareto chart based on cell color occurance in the excel sheet and show the number of counts along with their legend names.

The colour for specefic term are shown in legends,so we need to search for those colours in excel sheet and draw pareto map accordinly.

I have attached an excel sheet for better understanding....pls let me know if this can be done...

Regards
Ashesh