Presentation of a chart like in the appendix?

[Anonymous]

Hi all,

I want to know, if and how it is possible to present a chart like in the appendix.

There are different groups of data. Is this possible?

Ex:

Group	A	B
Test1
	ABC	.93
	DEF	23.4
Test2
	XYC	54
	dhj	64
etc	etc	etc

As you can see in the appendix - the example is very huge.

Thank you for helping.

[Anonymous]

Hi Robert,

How are your colours imported? Are manually or automatic?

How do you have calculated two bars? One by test?

Regards!!

[Anonymous]

Hi all,

here a new trial with explanations in the graph. Hope that's easier for you:

The collours are set automatically.

Regards

[Anonymous]

Hi,

I guess what you need is a combination of a stacked bar chart with legend and a pivot or straight table, showing the data.

Use the group of bacteria and the bacteria name as dimension and the first percentage as expression.

[Anonymous]

Hi Robert,

You need a stacked barchart and a pivot table. On pivot table you will calculate values for % for each group and item. The problem is that you need to calculate the colours to see the same colour on pivot table and barchart.

Regards!!

[Anonymous]

Thank you!

Can u give me an example with the data above?

Thank you very much

[Anonymous · Accepted solution]

See attached, I have calculated the colours on script.

Regards!