11 Replies Latest reply: Sep 11, 2012 1:43 AM by whiteline _

# How many expressions and dimensions can be usedin the bar chart?

Hi All,

How many expressions and dimensions can be usedin the bar chart?

Thanks,

Attitude

• ###### How many expressions and dimensions can be usedin the bar chart?

only two dimensions

and more than 1 expression

• ###### How many expressions and dimensions can be usedin the bar chart?

Hi Sunil

I have heard that we can use 3 dimensions and only one expression.

Thanks,

Attitude

• ###### How many expressions and dimensions can be usedin the bar chart?

It is the same thing. A bar chart can have dimensionality=3, which you can achieve by either 2 dimensions and an array of expressions (any number of expressions), or 3 dimensions and single expression./HIC

• ###### How many expressions and dimensions can be usedin the bar chart?

Hi Henric

So do you mean to say that maximum of 3 dimensionality can be used in bar chart?

Thanks,

Attitude

• ###### How many expressions and dimensions can be usedin the bar chart?

if we use third dimension then it will not appear in chart

• ###### How many expressions and dimensions can be usedin the bar chart?

Hi Sunil

Yes you are correct I also think the same. But I heard someone saying that we can use 3 dimension in the bar chart. So I want some justification from those people.

Thanks,

Attitude

• ###### Re: How many expressions and dimensions can be usedin the bar chart?

Yes, you can use three dimensions and one expression. See attachment. But you can argue that the bar chart gets cluttered and that you should not do it..

• ###### Re: How many expressions and dimensions can be usedin the bar chart?

Hi All,

As the discussion is on Bar chart's dimension and expression limit, I am using two dimensions and more than two expressions, then my bar chart is automatically converted into stacked style which i dont want, I want to show my expressions in Bar only, can any one tell me how to do that?

Regards,

Yojas

• ###### Re: How many expressions and dimensions can be usedin the bar chart?

Add a synthetic dimension (the last one):

=ValueLoop(1,2)

Then you can replace your 2 expressions with one:

=pick(ValueLoop(1,2), expression1, expression2)

• ###### Re: How many expressions and dimensions can be usedin the bar chart?

Hi Whiteline,

This is the different method I found aftter so many Reply. Do you have any example where you have used such type of expression? That wil be helpful for me.

Regards,

Yojas

• ###### Re: How many expressions and dimensions can be usedin the bar chart?

No, unfortunately.

It's rather simple, use what was mentioned above.

Just replace expressionN with your expressions.