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.

[Anil_Babu_Samineni]

Can you please provide the Expression, Which you taken over there?

[subbareddykm]

Normal sum only, with stacked one

[sunny_talwar]

This is the closed I managed to get with 5-10 minutes of play around with this. I am sure you can further fine tune this, but see if this is close to what you want

[sunny_talwar]

Added another way to do this without using valuelist

[Anil_Babu_Samineni]

The Reason is It's not possible with Two dimensions as you expected. Work around Try with Sunny T Solution. I am sure, I've read same kind of thread. I didn't remember his name. I think Manish Kachhia posted the similar. Hope he will explain you. Anyway, Once i reach i might can share that Application with you

Updated: Subba Reddy, Please find the link which Manish Provides the URL. Hope you will clear on this. And Thanks Manish for remind again

[sunny_talwar · Accepted solution]

Slight improvement by moving the reference lines between the two bars

[Anil_Babu_Samineni]

Sunny, What you added from Reference Line?

[nagarjuna_kotha]

May be like this .

Check and let me know

-Nagarjun

[subbareddykm]

Hoiw to add reference line?