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 (http://excelpoweruser.wordpress.com/2012/08/22/hook-chart/)

Thanks
Rajan.