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