Display dataset in Horizontal bar with offset in the Excel?
I have the following table
Start End Duration (years)
Bob Larkin September 1, 1924 October 1, 1932 8
Ed Jenkins January 1, 1925 September 1, 1943 18
Speed Dash March 15, 1925 March 1, 1930 4
Old Walrus January 20, 1926 May 5, 1927 1
Lester Leith January 1, 1929 June 1, 1943 14
Bob Zane June 7, 1930 July 21, 1934 4
I'd like to generate a horizontal bar chart with starting points for the bars according to their respective start date.
Excel represents dates as days since 1900. If you create a stacked bar chart for the start dates and the duration in days you get 2 bars for each person: one from the lower limit of the horizontal axis (1900-1-1) to the start date and another one from the start date to the end date. Make the the first ones invisible.
After some tweaking of the axes (set limits of horizontal axis to 8767 and 15950, and revert vertical axis) I get this:
- How to border cells based on where the user click?
- Difference between running a userform in Visual Basic Editor (F5) and opening it with Show?
- VBA delete row working in one for loop but not another
- How to get HEX color value from cell color?
- Remove columns if the number of rows is less than a certain number using vba Excel
- VBA Security : my vbe password is well-set, but still can be hacked by a simple code
- Adjust vertical scrollbar range in Excel userform listbox
- Delete user ribbon from file
- Excel Hide/Show all tabs on Ribbon except custom tab
- Partial value font color in red using vba
- How do I conditionally append a row of Excel data from one sheet to another?
- Efficient formula or code to determine number of errors in range VBA
- Rank numbers including NA()s in Excel 365
- Is it possible to have a named range attached to "activesheet," rather than a specific sheet?
- How to calculate YoY Growth without a Date Field in Pivot?
- Excel hyperlinks 'Can't open specified file' on Mac
- Is it possible to dynamically change a cell/column reference in an excell formula based on another cell
- Excel - create a list from a data column but ignore/remove blank cells
- Split text string in Excel by semicolons and space
- Formula in Excel to count occurrences of substrings within strings
- find closed match value in matrix and return its row and column header in excel
- VBA to allow users to format cells on locked worksheet
- How can my For Each Loop loop to the next row?
- Excel - Return value based in two conditions
- Power Query, M language, Count items in a row with Special condition
- excel group column highlight matching values
- VBA - Save email object (OLEFormat) to file from clipboard
- excel vba projects not closing
- Excel VBA variable Chart Range
- Changing the Date Format for GROUPED dates in a PIVOT TABLE