Creating Stacked Bar Chart

[#1]

Hi all,

I have a table which shows an overview of the different systems(system type, i.e. ERP system, Mail system, Sales system) implemented within a group of companies. The table looks like this.

I want to create a stacked bar chart. But I am facing some difficulties in creating a stacked bar chart which looks like this.

This is as far as I can get. The bars are categorised by the individual systems. rather than grouped by the family(ERP,Mail, Sales).

Is anyone able to advise me on what to do?

Thanks!

[Gysbert_Wassenaar]

In the load script split that field into two fields, one for the family and one for the system. Use these two fields as dimensions in the bar chart.

[#3]

Thanks for the reply.

Is there any sample code around which I can possibly reference?

[Gysbert_Wassenaar]

Very likely, but finding it could take a lot of time. Can you post an example source file?

[#5]

Here you go.

Thanks for your help.

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#7]

Hi Gysbert,

It does look like what I am trying to achieve on my app.

Let me try it on my actual data.

Thank you for your advice and being extremely helpful.