View Single Post
  #1   Report Post  
Aussie1497
 
Posts: n/a
Default create range bar graph


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/....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
...


--
Aussie1497
------------------------------------------------------------------------
Aussie1497's Profile: http://www.excelforum.com/member.php...o&userid=20117
View this thread: http://www.excelforum.com/showthread...hreadid=346877