Single column data comparision chart

[goels]

Hi All,

I am trying to build a chart which allows me to compare the following data. Both the data columns are part of a name range the names of which are also given :

Company Movement
Alpha 15
Bister 25
Cauldro 55
Jesip -5
Hezbir -28

The fashion I want to do the comparision is somewhat similar to a high-low-close stock chart; so all the data points are plotted on one single column structure one above the other starting from Hezbir at the bottom and Cauldro at the top with the others in between. All the companies should have a notch on the column and the movement and company name should be displayed next to the notch. So it will somewhat look like:

----------- 55, Cauldro




-----------25,Bister


------------15,Alpha




------------(5),Jessip





--------------(28)Hezbir

Could someone please advise on how to build this kind of a chart.

Thanks

[zbor]

Like this:

[goels]

Hi zbor,

Thanks. I should had explained better though - I was looking for a chart along the lines I have drawn in the attached xls file rather than a stacked chart. So as you will see in the drawing Cauldro which has a movement of 55 has a notch line at 55 rather than 95 and so on.Thanks

[goels]

Hi zbor, all,

Any ideas on how this kind of a chart can be done in excel?

Thanks