Add Excel objects

[John-SSI]

Hi all,

Is there a possibility to add a piechart in the excel-template that then can show the data in the report?

The data in the report can be more and less rows from day to day.
Or should i build an table that's is calculated.

The data from  Qlik is:

ServiceArea	Cause1	AllWo
4	Control	1
7	Control	1
3	Electrical	1
4	Electrical	1
1	IT/WAMAS	1
2	IT/WAMAS	2
1	Mechanical	2
2	Mechanical	4
4	Mechanical	1
5	Mechanical	14
10	Mechanical	3
4	Product	2
5	Product	1
1	Unit Load	2
4	Unit Load	1
1	-	4
2	-	2
5	-	3

And if i use chartguide in Excel it transforn to this:

And the result is this:

Is this possible?

[John-SSI]

Hmm, next question, i can get i right.

When i try to create a Excel chart i only take the first values.
Is there a trick to get this right?

Br
John

[Lech_Miszkiewicz]

Hi @John-SSI , 

I normally use Excel Table and reference table in chart. Also I add 1 extra row under data <tags> and I put in that extra row <deleterow> tag to remove it later.

cheers