Floating Bar Chart ?

I have a number of measurements that I would like to bar chart. Each measurement is "from - to", that is to say each measurement has a staring value and an ending value, for example

Measurement Start End
1----------------10------20
2----------------20------60
3-------------minus 5----40

What I would like to do is chart these in such a way that I get a bar which starts at the start value and ends at the end value. I have got as far as charting the end values correctly by using the 'stacked column' chart type with two series - the start value and the difference - and making the start value bar transparent, and this works if all the values are positive. The problem is, it doesn't show the negative part of the bar.

Is there a way to achieve this (am using Excel 2002) ?

Addendum : I just realised you can do this with the 'stock' chart type (using an arbitrary middle point as closing price), but you can only chart the values as lines, not columns. Is there a way to make the lines into columns ?

Hi,

Take a look at Jon's brilliant solution
http://peltiertech.com/Excel/Charts/...ngColumns.html

Originally Posted by Blewyn

Carim,

Thanks for the link, but I still have a problem. My data includes negative 'start' values. so for example my data can be :

start end

-10 30
-20 40

When I try to plot using the 2-series method described in the link, the negative portion of the bar doesn't show - because the bar is actually a value related to the axis origin (zero). How can I make floating bars that includes subzero values ?

Hi,

would you like to post a sample chart, with a small amount of relative data.

---