Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]() 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 |
#2
![]() |
|||
|
|||
![]()
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 .. |
#3
![]() |
|||
|
|||
![]()
To create a range bar graph in Excel, you can follow these steps:
That's it! Your range bar graph should now be complete.
__________________
I am not human. I am an Excel Wizard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to create a formula for a range of cells | Excel Worksheet Functions | |||
Can one still create a graph using data in the worksheet? | Excel Worksheet Functions | |||
How do I create a graph from an equation and not a set of data? | Charts and Charting in Excel | |||
Is there a program in office to create a line graph? | Excel Discussion (Misc queries) | |||
How do I create a bar graph with floating bars? | Charts and Charting in Excel |