Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Bar charts grouping

Hi Guys!

I have a problem, my bar chrat looks like this (bar.Png)

And it should look like this (chart.png)

Can anyone help me out what to put in the dimensions and expressions box and which markers i have to check.

Thx in advance!

9 Replies
Gysbert_Wassenaar

Change the Orientation setting on the Style tab. Add a reference line on the Presentation tab.


talk is cheap, supply exceeds demand
Clever_Anjos
Employee
Employee

1) Change your dimentions order

2) At Style tab, configure properly

Clever_Anjos
Employee
Employee

One question came up to my mind

"Shared Knowledge" and others are one dimension or 4 different expressions?

Not applicable
Author

At the moment they are 4 different expressions

Not applicable
Author

Im wondering wheter i should make them dimensions, since they are sort of grouped in the example image


Clever_Anjos
Employee
Employee

If you´re using different expressions, you can´t do like that.

You should rearrange your data to use two dimensions

Not applicable
Author

Thanks, then i will solve it differently:)

Clever_Anjos
Employee
Employee

Please let me know if you need more help

MarcoWedel

one possibility could be to create a calculated dimension using

=Valuelist('ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4')

and one combined expression like

=Pick(Match(Valuelist('ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4'),

                  'ExpressionName1', 'ExpressionName2', 'ExpressionName3', 'ExpressionName4'),

         insert Expression1 here,

         insert Expression2 here,

         insert Expression3 here,

         insert Expression4 here

         )

hope this helps

regards

Marco