Showing Data by Hook
See the post here
http://excelpoweruser.wordpress.com/2012/08/22/hook-chart/
Regards
Rajan verma
Printable View
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.
you can download the chart from hereHTML 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
Thanks
Rajan.