10 Replies Latest reply: Apr 11, 2014 2:27 AM by Jelly CHEN

Area Chart(or line chart) in chart table

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?

• Re: Area Chart(or line chart) in chart table

May be like attached sample?

• Re: Area Chart(or line chart) in chart table

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....

• Re: Area Chart(or line chart) in chart table

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

• Re: Area Chart(or line chart) in chart table

Expression tab-> check 'Relative'

• Re: Area Chart(or line chart) in chart table

Thanks so much!

• Re: Area Chart(or line chart) in chart table

A further question....

How can I change the order of Y-Value?

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

• Re: Area Chart(or line chart) in chart table

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%......

• Re: Area Chart(or line chart) in chart table

Expression tab-> check 'Full Accumulation'

• Re: Area Chart(or line chart) in chart table

I have tried but i doesn't work. I would like the final chart like this .....