Hook Chart

Showing Data by Hook

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

Regards
Rajan verma

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

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.

HTML Code:

---


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.