Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Can you pl post a sample data nad explan us in excel
-Sridhar
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
Hi, have you found any solution for it?