Hook Chart

[Rajan_Verma]

Showing Data by Hook

See the post here
http://excelpoweruser.wordpress.com/2012/08/22/hook-chart/

Regards
Rajan verma

[Pravee89]

Rajan,

That's a nice chart where you can compare the sales of different variables. I just want to know how did you do the chart. You have used Series formula for the chart which i couldn't understand.
It would be really helpful if you explain about how you prepared this chart.

Thanks in advance

[Rajan_Verma]

Hi
Sorry for the delay post :

Basically this chart is a Stacked bar chart the it has thee Point in one Series, the second Point of every series has a minimum value, showing in below table , and the trick is, i create border of Second point only , so that it can be view as a Hook in a series.

P1	21	0.2	78.8
P2	30	0.2	69.8
P3	20	0.2	79.8
P4	25	0.2	74.8
P5	43	0.2	56.8
P6	29	0.2	70.8
P7	21	0.2	78.8
P8	31	0.2	68.8
P9	36	0.2	63.8
P10	22	0.2	77.8
P11	46	0.2	53.8
P12	18	0.2	81.8

you can download the chart from here

Thanks
Rajan.