problem in weighted avg

[#1]

Hi

i have list of companies with sales,cost,etc

i have calculated the weighted avg of all the comlanies using some formulas.....

if the overall wt.avg is 20% consider........

consider xxx company wt.avg is 24% and yyy is 16%

I want to show the chart with companies list as X-axis

And Y-axis should show the value for xxx is 4% and yyy is -4%

that is we should subtract the value of individual wt.avg to overall wt.avg....

can any one explain how to do this.........

thanks in advance

[#2]

Hi,

Can you pl post a sample data nad explan us in excel

-Sridhar

[#3]

Company Profit Depreciation Income

XXXX 20,500 15,000 50,000

YYYY 25000 17000 55,000

ZZZZ 70,000 20,000 80,000

Wt.Avg=(Profit*(Depreciation/Income))/Profit

[#4]

Hi, have you found any solution for it?