Hi,

I would need some advice on designing a stacked column graph. I need a stacked graph like this :
and I'm able to achieve this by dummy data,by appending the data.

However, when I replicate the same logic flow for the data in my database, it behaved differently.
The Append Data Action:

Data Appended: And I ended up with this stacked graph:

Which is incorrect. It should have Selangau under Central while Bintulu Office stays under Bintulu. Is this due to small sample of data? But when the data grow, there will be more data series in either Bintulu or Selangau.

The following are my chart's properties:

Thanks in advanced for any advices or suggestions from the community! Your feedback is very welcomed!

Regards,

Kenny