Combo Chart

[subbareddykm]

Hi all,

LOAD * INLINE [

    Company, Area, Yes, NO, ID2

    Test, AAA, 20, 15, 0

    Test, AAA, 23, 16, 1

    Test, AAA, 28, 17, 2

    Test, AAA, 33, 18, 3

    Test, AAA, 38, 19, 4

    Test, AAA, 43, 20, 5

    Test, AAA, 48, 21, 6

    Test, BBB, 53, 20, 7

    Test, BBB, 58, 18, 8

    Test, BBB, 63, 16, 9

    Test, BBB, 68, 14, 10

    Test, BBB, 73, 12, 11

    Test, BBB, 78, 10, 12

    Test, BBB, 83, 8, 13

    Test, CCC, 88, 6, 14

    Test, CCC, 93, 4, 15

    Test, CCC, 98, 2, 16

    Test, CCC, 103, 0, 17

    Test, CCC, 108, 0, 18

    Test, CCC, 113, 0, 19

    Test, CCC, 118, 0, 20

];

By using above data is it possible to show chart like below

I m not able get it , coming like below and also idont have idea how to create those reference liness

Did any one created this kind of chart.

[sunny_talwar]

You will have to change your dimension to be a continuous dimension on the axis tab to be able to add vertical reference lines

[sunny_talwar]

Anil I don't understand your question, can you may be re-frame it for me?

[nagarjuna_kotha]

In presentation tab u can see reference line. u can add threre expressions.

I hope this may helps u

-Nagarjun

[Anil_Babu_Samineni]

Haha, I am asking you about Reference Line. I don't have license at this point. What you have done from there to get the Ref Lines. Hope Clear

[sunny_talwar]

1) Changed to continuous on the axis tab (as I mentioned in my above response to OP)

2) Once you enable continuous, you will see a third option becoming available within Reference lines

I hope that answers you question

[MK_QSL]

Anil babu

Multi Dimensional Bar Chart

[subbareddykm]

Sunny if i take dimention as a date instead of ID , my date field is not showing date it is showing as Number only that is becoz of continues option in axis tab.If i de slect that continues reference lines are now showing,

Is there any solution for it,?

[sunny_talwar]

Yes there is, got to the numbers tab and select Continuous X-axis and then use Date as Number Format settings