A Challenge: 100% Stacked area chart

Situation:
stocks belonging to different sectors.
60 different stocks. 9 different sectors. Stocks only belong to one sector.
Each stock has a weight. Sum of all stocks is 100.

I need to create a graph with the following features.
on the x axis is the name of the sector. on the y-axis is 0%-100%
stocks are stacked on top of each other till the sector =100% (ie a sector with only one stock will have only one color in its column)

I've been able to do up till this part.

1: Instead of the data label saying the percentage it needs to say the stock name. (and no, changing the data label options to Series Name does not work. a glitch i think. Does excel need to be updated to fix this?) excel 2010*

2: the width of the x-axis (sector) needs to be representative of the total weight of the sector relative to the sum of the sectors. IE if one sector made up 50% of the total, it's bar should be half of the chart.

i should specify that the stocks names and weights are in columns, the sector names are in rows

---------- Post added at 01:40 PM ---------- Previous post was at 01:38 PM ----------

#1 has been resolved using a macro, only #2 is left.