negative duration in days not showing in chart

[Kim B]

Hello All, the negative duration in this table isn't showing in the chart. Date range is at the top, task name is vertical axis

Sheet1

	B	C	D	E
Out to Bid
Bid reviews
Board presentation for approval
Contract Awarded
Work begins

<tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]
[TD="bgcolor: #ffcc00"]Task Name[/TD]
[TD="bgcolor: #ffcc00"]Start[/TD]
[TD="bgcolor: #ffcc00"]End[/TD]
[TD="bgcolor: #ffcc00"]Duration (days)[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="align: left"]Plans 90 %[/TD]
[TD="align: left"]10/1/2017[/TD]
[TD="align: left"]10/27/2017[/TD]
[TD="align: left"]26[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="align: left"]Plans 100 %[/TD]
[TD="align: left"]10/27/2017[/TD]
[TD="align: left"]11/17/2017[/TD]
[TD="align: left"]21[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="align: left"]Documents bid specs Prepared for submission Dewberry[/TD]
[TD="align: left"]11/20/2017[/TD]
[TD="align: left"]12/8/2017[/TD]
[TD="align: left"]18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="align: left"]Warwick Docs prepare[/TD]
[TD="align: left"]12/11/2017[/TD]
[TD="align: left"]12/15/2017[/TD]
[TD="align: left"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]

[TD="align: left"]12/18/2017[/TD]
[TD="align: left"]1/5/2018[/TD]
[TD="align: left"]18[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]

[TD="align: left"]1/8/2018[/TD]
[TD="align: left"]1/12/2018[/TD]
[TD="align: left"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]

[TD="align: left"]1/24/2018[/TD]
[TD="align: left"]1/25/2017[/TD]
[TD="align: left"]-364[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]

[TD="align: left"]1/29/2018[/TD]
[TD="align: left"]2/2/2018[/TD]
[TD="align: left"]4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]

[TD="align: left"]2/5/2018[/TD]
[TD="align: left"]5/16/2018[/TD]
[TD="align: left"]100[/TD]

</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

 

[pbornemeier]

Excel does not like negative dates. Be sure that the column that is not showing in the chart that contains negative values is formatted as a number in the chart. The chart may be converting it to a date since there are other dates in your table.

 

[Kim B]

It is a tricky one, maybe it can't be done, all the other time line results are general formatting, I did change them all to number formatting and that time line still isn't showing.

 

[pbornemeier]

What type of chart?

 

[Kim B]

Bar, so i would expect the bar to go backwards from the others, starting right and going back to the left, where the others start left and go forward to the right

 

[pbornemeier]

I highlighted B7:E15 and added a Clustered Bar Chart. This is the formula that was created:
=SERIES(,Sheet1!$B$7:$D$15,Sheet1!$E$7:$E$15,1)

The 'Board Presentation' bar is going to the left, the others are going to the right. I am not sure why yours is not doing that. Try the date in a new workbook in case the current one is corrupted in some way.

That kind of info is well-represented by a Gantt chart. This site: https://www.smartsheet.com/blog/gantt-chart-excel
Shows how to set it up in Excel.

 

[Kim B]

Mine reads similar

SERIES(,Sheet1!$B$5:$c$5,Sheet1!$b$7:$c$18,Sheet1!$e$5,Sheet1!$E$7:$E$18)