Want to create a combo chart with grouping.

[#1]

Hi,

Below is my data set.

X	Y	Product	Sum of Value
X1	Y1	P1	1
X1	Y1	P10	9
X1	Y1	P2	6
X1	Y1	P3	3
X1	Y1	P4	5
X1	Y1	P5	7
X1	Y1	P6	3
X1	Y1	P7	5
X1	Y1	P8	7
X1	Y1	P9	8
X2	Y2	P1	8.8
X2	Y2	P10	14.36363636
X2	Y2	P11	14.98181818
X2	Y2	P12	15.6
X2	Y2	P13	16.21818182
X2	Y2	P14	16.83636364
X2	Y2	P15	17.45454545
X2	Y2	P2	9.418181818
X2	Y2	P3	10.03636364
X2	Y2	P4	10.65454545
X2	Y2	P5	11.27272727
X2	Y2	P6	11.89090909
X2	Y2	P7	12.50909091
X2	Y2	P8	13.12727273
X2	Y2	P9	13.74545455
X3	Y3	P1	18.07272727
X3	Y3	P10	23.63636364
X3	Y3	P11	24.25454545
X3	Y3	P12	24.87272727
X3	Y3	P13	25.49090909
X3	Y3	P14	26.10909091
X3	Y3	P15	26.72727273
X3	Y3	P2	18.69090909
X3	Y3	P3	19.30909091
X3	Y3	P4	19.92727273
X3	Y3	P5	20.54545455
X3	Y3	P6	21.16363636
X3	Y3	P7	21.78181818
X3	Y3	P8	22.4
X3	Y3	P9	23.01818182
X4	Y4	P1	27.34545455
X4	Y4	P2	27.96363636
X4	Y4	P3	28.58181818
X4	Y4	P4	29.2
X4	Y4	P5	29.81818182
X4	Y4	P6	30.43636364
X4	Y4	P7	31.05454545
X4	Y4	P8	31.67272727
X4	Y4	P9	32.29090909

And I want to create a graph like attached image.

Can someone help me to figure out, how to do it.

Thanks & Regards,

Juthika

[#2]

I tried out few extensions. Thank you for your suggestions