Need to create stack bar graph

[#1]

Dear All,

Greetings for the day.

I need to create a stack bar graph. X axis is "Month" and Y axis is "Sum(qty)". Now I need this Y axis bar as stack bar based on field "Customer Code".

I have 200 Customer code's in my file. So i can't give those many expression's. So Is there any other way to create stack bar based on customer code.

Please let me know how to create same. Thanks in advance.

[muniyandi]

Hi reena,

can you post some sample file.

Regards,

Muni

[tresesco · Accepted solution]

Use 'Customer Code' as second dimnesion. Goto Style tab->Sub Type->Stacked

[Anonymous]

Use Month and Customer as dimension and sum(qty) as expression.

Now in Style tab , change Subtype from Grouped to Stacked.

You will get the stack chart.

Regards

Nitin

[Anonymous]

Hi Reena,

You Can Add the Month & Customer Code into Dimension & in Expression you can write sum(qty).

then go to Style Tab select subtype as Stacked.

It will give you your expected output.

hope this help.

Regards,

[muniyandi]

Hi ,

Kindly verify my attachment file.

Regards,

Muni

[MK_QSL]

Like this?

[#8]

Thanks for replies. I got the solution.