stacked chart percentage

[LukasPij]

[FONT=&quot]Heey guys,

[/FONT]
[FONT=&quot]Does anyone have some experience on the problem below? I am having the following problems when trying to create a stacked chart. I would like to make adjustment in the chart below.

[/FONT]
[FONT=&quot]Since I would like to make a similar chart with different data. For this example, assume the y-axis is different (e.g. % total revenue generated by selling televisions) and that the numbers in the chart stay the same.

I would like to adjust the chart in a way so that I can create a stacked chart, for example i would like to depict in the chart:
1999: 10 % of total revenue generated by selling televisions, of this 10%:
- 40 % plasma tv
- 30 % amoled tv
- 30 % led tv


2000: 11% of total revenue generated by selling televisions, of this 11%:
- 60 % plasma tv
- 20 % amoled tv
- 20 % led tv
[/FONT]

 

[thisoldman]

I find it's difficult to make comparisons using stacked column charts but if you want to do it, here's one way. I've just plugged in some dummy numbers for the known values.

I extended the data beyond what is posted here. The known values are in columns A through F. Values in columns H through L are calculated from these known values.

	A	B	C	D	E	F	G	H	I	J	K	L
1				% of Total TV
2	Year	Total Rev	Total TV	Plasma	AMOLED	LED		All TV	Other	Plasma	AMOLED	LED
3	1999	12,000	10%	33%	11%	56%		1,200	10,800	397	132	671
4	2000	13,000	11%	44%	13%	43%		1,430	11,570	631	186	613
5	2001	14,000	12%	49%	13%	38%		1,680	12,320	818	218	643

<tbody>
</tbody>

Data
​

Worksheet Formulas Cell Formula H3 =B3*C3 I3 =B3 - H3 J3 =D3*H3 K3 =H3*E3 L3 =F3*H3 <tbody> </tbody>

<tbody>
</tbody>

For the first chart, select the data in columns A and I through L. Then on the ribbon, select Insert >> Column Chart >> Stacked Column.

For the second chart, select the data in columns A and J through L. Insert another stacked column chart.