Area Chart(or line chart) in chart table

[#1]

Hi All

Now I have a serious steps in Excel:

1. Original Table

Year	Product	Grade
2011	1	A
2011	2	A
2011	3	B
2011	4	B
2011	5	B
2011	6	C
2011	7	C
2011	8	C
2011	9	C
2010	10	A
2010	11	B
2010	12	B
2010	13	C
2010	14	C
2010	15	C
2009	16	A
2009	17	A
2009	18	A
2009	19	A
2009	20	B
2009	21	C

2.

	2011	2010	2009
A	2	1	4
B	3	2	1
C	4	3	1
Total	9	6	6

3.

	2011	2010	2009
A	22%	17%	67%
B	33%	33%	17%
C	44%	50%	17%
Total	100%	100%	100%

4.And Then I could insert a line chart:

And My question is How can I just load the original data from my data source and insert the final area chart directly?

[tresesco]

May be like attached sample?

[#3]

Thanks!

I would like to count the number of grade and get their % of total sample in one year, not sum of the product. The number of product just a mark....

[tresesco]

Change the expression accordingly. =Count(Grade)

[#5]

How can you get the % of the count(grade) of that year?

[tresesco · Accepted solution]

Expression tab-> check 'Relative'

[#7]

Thanks so much!

[#8]

A further question....

How can I change the order of Y-Value?

I just try many time and could not find it....

[#9]

I follow your method to click the 'Relative', it seems that the % if of the whole sample not just for that specific year, so the accumulated area of the % is not 100%......

[tresesco]

Expression tab-> check 'Full Accumulation'