stacked barchart into batchart

[#1]

im using 2 dimensions and morethan 1 expression then barchart show stacked

but i dont need stacked hoe to resolve this

im using trellis chart but it not good

plz give me the reply.

Thanks

[#2]

u need trellis chart ?

how many dimensions & exprs in total ?

[#3]

Hi

i have 2 dimensions and 2 expressions

in the style -subtype of the chart is grouped but it display as stacked

plz give without trellis chart

[#4]

hi

thanks for the reply

i dont need trellis chart

i have 2 dimensions and 2 expressions

then it automatically show as stacked

[#5]

cud u pls post ur sample qvw....thoda check karna hoga abt exprs

Regards

[#6]

Hi

now im using qv personal edition

in my chart 2 dimensions

for sample

empno,ename

expressiona

sum(sal),avg(sal)

im using just sample data

my chart display like this

[Gysbert_Wassenaar · Accepted solution]

You have two dimensions and two expressions. Try using one calculated dimension: empno & ' ' & ename instead of both ename and empno. I assume that there's a one-to-one relation between ename and empno.

[#8]

Hi

Thank you for your valueble information

now i get it.

[#9]

so does it mean that if there is one to many relation between two dimensions then it shud nt show stacked?

[Gysbert_Wassenaar]

That depends. If you are aware of it and you want to show the combinations then you can do it that way. I assumed that ename and empno actually represent the same thing, an employee, so there is no need to use both dimensions.

A bar chart can show only three independent variables. So you're limited to two dimensions and one expression or one dimension and two expressions. If you have a hierarchy of dimensions (like year,quarter,month) you can 'stack' them on one axis.