Which chart item suits best as I used Bar chart but the layout is not proper?

[#1]

Hi,

Dimension 1: Member_sheetA

Dimension 2: Test

Expression: =Num(Count({<Result={'Fail'}>} Distinct Reference_SheetA)) / Num(Count(Distinct Reference_SheetA))

can anyone suggest me which chart item suits best as I used Bar chart but the layout is not proper and tried with other charts. I jsu got confusion to use which chart.

Thanks.

[#2]

Please see attached.

[its_anandrjs]

Hi,

You Have to use Straight table or Pivot table otherwise make some changes in the bar scale by right click on chart -> Axes -> Scale -> then set here Static Min, Static Max and Static Sep then it will be better.

Thanks & Regards

[#4]

Thanks. Can you suggest the figures if possible to give in Static Min , Static Max  and Static Step.

I used but it seems not showing correct in bars.

[maxgro]

[its_anandrjs]

Hi,

In your check which is the minimum value and maximum value change according to that and make separate value otherwise best option is pivot table.

Thanks & Regards

[#7]

can I know how you split like this?

EDIT: I suppose it is trellis right?

[#8]

Thanks. I already have pivot table. so now looking to use graph chart.

[its_anandrjs]

Hi,

Try to use Grid Chart in place of trellis and trellis chart is created from chart properties -> Dimension ->Trellis button.

Thanks & Regards

[maxgro]

yes a trellis

see attachment