Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Area Chart(or line chart) in chart table

Hi All

Now I have a serious steps in Excel:

1. Original Table

YearProductGrade
20111A
20112A
20113B
20114B
20115B
20116C
20117C
20118C
20119C
201010A
201011B
201012B
201013C
201014C
201015C
200916A
200917A
200918A
200919A
200920B
200921C

2.

201120102009
A214
B321
C431
Total966

3.

201120102009
A22%17%67%
B33%33%17%
C44%50%17%
Total100%100%100%

4.And Then I could insert a line chart:

111.jpg

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

10 Replies
Not applicable
Author

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