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

Answer: create range bar graph
 

To create a range bar graph in Excel, you can follow these steps:

1. Enter your data into Excel. In your example, you have a list of tasks and their corresponding ranges.
2. Select the data you want to use for your graph.
3. Go to the Insert tab on the ribbon.
4. Click on the Bar chart type.
5. Select the Range Bar chart subtype.
6. Your range bar graph should now be created.
7. You can customize your graph by adding a title, changing the colors, and adjusting the axis labels.
8. To add labels to each bar, right-click on the chart and select "Add Data Labels."
9. You can also adjust the spacing between the bars by right-clicking on the chart and selecting "Format Data Series." From there, you can adjust the "Gap Width" to your desired spacing.

That's it! Your range bar graph should now be complete.

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

Aussie1497 wrote:

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