how to create stack chart in webi ?

[Former Member]

Dear Expert,

I need your help,

Please see the attached table screen shot, and graph screen shot,

I have done in excel and its showing graph but its not showing in webi.

Please see the webi graph, I want same as excel graph.

Please help me to resolve this issue.

Regards,

Divyesh Patel

(9930578182)

[arijit_das]

looks like you have three measures and two dimensions. there should be one measure and the measure names should appear as dimension values.

Dimension 1	Dimension 2	Measure Name	Measure
D21	Dim 11	m1	12
D21	Dim 11	m2	13
D21	Dim 11	m3	21
D21	Dim 12	m1	72
D21	Dim 12	m2	109
D21	Dim 12	m3	54
D22	Dim 11	m1	32
D22	Dim 11	m2	45
D22	Dim 11	m3	32
D22	Dim 12	m1	92
D22	Dim 12	m2	141
D22	Dim 12	m3	65
D23	Dim 11	m1	52
D23	Dim 11	m2	77
D23	Dim 11	m3	43
D23	Dim 12	m1	112
D23	Dim 12	m2	173
D23	Dim 12	m3	76

[Former Member]

Hi,

Thanks for your prompt reply , I have 3 measure 1) Actual 2) Plan 3) Variance

and 2 Dimension 1) Cost element and 2) Quarter.

Please let me know how to create chart.

Please see the below screen shot.

Regards,

Divyesh Patel

(9930578182)

[Former Member]

HI,

have a look at

Regards,

Rogerio

[Former Member]

Hi,

Thanks for reply, Its very help full.

Regards,

Divyesh Patel

(9930578182)

[Former Member]

which values (measures) you are diplaying in the graphs.

I can't see any difference in both the graphs!

Please explain in details.

Thnaks,

Swapnil