create range bar graph

[Aussie1497]

I need to create a range bar graph in excel. Basically given an end
point for each corresponding value on the y-axis it'll plot a
horizontal bar up to that endpoint. The next horizontal bar will
continue for where the prev. ended.

Similar to this:
http://www.ncsu.edu/labwrite/res/gh/gh-bargraph.html#rangebar

How would I do it?
Many Thanks!

Example Data:

Task1 --> Range 0-30
Task2 --> Range 31-46
Task3 --> Range 46-48
Task4 --> Range 48-60
Task5 --> Range 61-70
...

 

[Jon Peltier]

These are called floating bar or column charts. You need two series, one
for the value from the axis up to the bottom of the column, and the
other for the height of the column (top minus bottom). Create a stacked
chart, and format the bottom column with no fill and no lines, so it's
not seen in the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______